Software Wiki Q&A Wiki Know-how

excel

excel

Matching All Articles
  • How to Insert Table from Excel to PowerPoint
  •    ►If you want to creat a new excel table, then choose , and choose the type you need in the Object type, then click OK.â–ºYou can also insert Excel table by clicking Table in the menu bar and select Excel Spreadsheet from the list. Â
  • How to Change the Font in an Excel Header or Footer
  • Click the worksheet which contains headers or footers that you want to change. Under the Insert tab, click Header & Footer in the Text group. Choose the header or footer you want to change, then it will pop up a font change window
  • How to Insert Excel table to Word
  • Open your excel document, select the table you want to paste, press Ctrl+C. Insert excel table to word 01 Go to your document in Word, put the cursor in the area where you want to insert the table, select Home> Paste, choose Paste Spec
  • How to Encrypt My Excel files
  • Provided that you have some private excel files that requires extra protection from others, or you have to send these sensitive excel files to somebody yet worry about it being intercepted, it’s sensible for you to encrypt your excel file
  • How to Transfer Data from Word to Excel
  • Sometime I need to copy a table on the Word document to excel and it may turn out to be different results. It snaps into the spreadsheet cell or keep borders and font formatting in the spreadsheet. I want to know how can I transfer data fro
  • How to Keep an Excel Chart Updated in a Word Document
  • Open a excel Chart which you want to update. Select the chart, and press ctrl+ c to copy it. Open a document, select a position, and in Home tab, click Paste Special in the drop down of Paste. On the Paste Special dialog box, select Micro
  • How to Add text to a Shape in Excel
  • Open excel that you want to add text to a shape. Click Shapes in the Insert tab, and choose a shape you like in the drop down menu, click it. In Excel, position your mouse where you want to insert, and drag mouse to insert the shape, now,
  • How to Reshape Shapes in Excel
  • Before reshaping shapes, you should have a shape. If you don't have a shape, insert one first.Click Shapes in the Insert tab, and choose a style you like in the drop down menu, click it. Position your mouse you want to insert, and drag mou
  • How to Change a Comment’s Shape in Excel
  • Open excel which has a comment.Because there isn't a toolbar to change comment's shape directly, you must add the toolbar first. Click Office button, and click Excel Options at the bottom. On the left, choose Customize, and choose Drawing T
  • How to Edit or Delete Cell Comments in Excel
  • Open an excel file which contains cell comments which you want to edit. Right click the cell you will edit comment, and choose Edit Comment. Or press "Shift + F2" to edit comment. In the comment text box, edit your comments. And after editi
  • How to Hide and show Cell Comments in Excel
  • Open an excel file which contains cell comments. Right click the cell with comment, click Show/Hide Comments. Now, you will see the comment directly even if you don't position the cursor to the cell. Right click cell again, check Hide Comme
  • How to Read all of the Comments in a Workbook in Excel
  • Open excel which contains some comments, if there is no more cell comments, you insert some comments first one by one. The way of reading the comments one by one: click Next or Previous in the Review tab to read all of the comments. The s
  • How to Create a Workbook from a Template in Excel
  • Click the Microsoft Office Button, and then click New button from the menu list.  If you want to use the recently used template, click Blank and recent option under Templates tab. Select the template under Recently Used Template and cl
  • How to Print Cell Gridlines in Excel
  • Open excel document you want to print. Click Page Layout, and click the Page Setup icon. In the Page Setup dialog box, click Sheet tab, and check Gridlines, at last click OK. Now, you will print cell gridlines.
  • How to Merge Styles from Other Workbooks in Excel
  • Open the workbooks that contains the wanted styles. Open the workbook that you want to copy the styles into. Active the workbook that you want to copy the styles into. On the Home tab, click Cell Styles in the Styles group. If you do not
  • How to Add a Background Image to a Worksheet in Excel
  • Active the worksheet that you want to add a background image. Click Page Layout tab on the top and click Background  menuin the Page Setup group. Locate the picture that you want to add, and then click Insert button to add it. Now the
  • How to Chang Text Alignment of Cell in Excel
  • In excel, the numbers align right and the text aligns left by default. However you can change it by following steps. Select the cell that contains the text that you want to change the alignment. The steps below are carried out in the Alig
  • How to Display the Current Time in Excel
  • Open Microsoft excel.  Enter the following formula in cell A1 in excel: "=NOW( )-TODAY( )", and press Enter on the keyboard, You can see the current time as a time serial number.                   current time If you
  • How to Remove Duplicate Rows from a Table in Excel
  • This will add the Design tab under Table Tools in excel. Choose Remove Duplicates in the Tools group . Then it will pop up the Remove Duplicates dialog box. Choose the columns you want to remove duplicates from on the Columns area. Here y
  • How to View a Worksheet in Multiple Windows in Excel
  • Now you can view a worksheet in multiple windows in excel. Worksheets that you want to view are in the different workbooks: Open the workbooks that contain the wanted worksheets.  Click on the View tab on the top. Click Arrange All men
Click here to view all results