Microsoft Excel Tips and Tricks


Here are the 10 Microsoft Excel tips and techniques:



Tip 1: To quickly move between multiple workbooks or worksheets

  • To move between open workbooks, press Ctrl+Tab.
  • To move to the next sheet in a workbook, press Ctrl+Page Down.
  • To move to the previous sheet in a workbook, press Ctrl+Page Up.


Tip 2: To do creative calculations with paste special

  • In an empty cell, type -1.
  • Select the cell, and click Copy from the Edit menu.
  • Now select (highlight) the cells containing the values you want to change.
  • From the Edit menu, click Paste Special.
  • From the Paste Special dialog box, Paste section, click Values and under Operation section, click Multiply.
  • Click on the OK button.
Note: All the numbers change from positive to negative, or vice versa. This method is also useful for reducing numbers by a factor of 1,000; 1,000,000, and so on.


Tip 3: To edit cells without using the mouse

  • Use the arrow keys to select the cell you want to edit.
  • Then press F2 key to edit the cell contents.
  • When finished, just press Enter to apply the changes or press Esc to cancel the changes.


Tip 4: To add a calculator to the excel toolbar

  • On the View menu, click Toolbars, and then click Customize.
  • Click the Commands tab.
  • In the Categories: list, click Tools, and in the Commands: list, click Custom (Important: The one with the gray calculator graphic!).
  • Drag the selected command from the Commands: list to a toolbar.
  • Click Close.


Tip 5: To apply a series using drag and drop techniques

  • Enter a value, such as MONDAY and press Enter.
  • Move the mouse cursor to the bottom right-hand corner of the selected cell, until the cursor changes to the shape of a fine cross-hair.
  • While depressing the left-hand mouse button, drag down the cells.
  • When you release the mouse button, the selected cells will be filled with the series.


Tip 6: To show or hide the formulas

  • When you're working in an Excel worksheet, you can alternate between viewing the values in the cells and displaying the formulas.
  • To toggle between the different views, press CTRL+` (single left quotation mark).
Note: If you're having trouble finding the single left quotation mark, it's on the same key as the "~" symbol.


Tip 7: To reference cells in other worksheets

  • For an Excel formula that needs to reference a cell in a different worksheet in the same workbook, use the following format for your formula:SheetName!CellAddress (Precede with the worksheet name, follow with an exclamation mark and last with the cell address)
  • For worksheet names that include one or more spaces, you will need to enclose it in single quotation marks.
  • The following is a formula that refers to a cell on a sheet by the name of Weekly Sales: =C8*'Weekly Sales'!A10


Tip 8: To create a Chart with the push of a keyboard button

  • Select the data you want to include in the chart.
  • Press F11 key or the Alt+F1 key.


Tip 9: To turn on the gridlines so that they will be printed

  • From the File menu, choose Page Setup to display the Page Setup dialog box.
  • Select the Sheet tab.
  • Check the Gridlines check box in the Print area.
  • Click on the OK button.


Tip 10: To build vertical titles

  • Select the cell that contains your text as well as the surrounding cells that you want your title to span.
  • On the Format menu, click Cells, and then click the Alignment tab.
  • In the degrees text box, enter 90.
  • Select the Merge cells text box.
  • Click on the OK button.

To get more undocumented Excel tips and tricks, please subscribe to our popular MS Office Tips newsletter.

Get FREE ebooks!
(Click for more info)

Subscribe to...
MS Office Tips Newsletter

E-mail Address:
First Name:
Then

Don't worry -- your e-mail address is totally secure.
I promise to use it only to send you MS Office Tips.



Can't find what you're looking for? Try Google Search!

Google
 

Back to Top


You're viewing the Excel Tips and Tricks info page, click here to go back to the Home Page