Keyboard tips for excel 2007

ALT+F1 – This creates a chart out of the data in the current range (selected cells). This is the most well known feature of Excel, and now you know a new way to use it!

ALT+SHIFT+F1 – This inserts a new worksheet into the workbook.

F6 – This switches between the worksheet, Ribbon, task pane, and Zoom controls. This is probably the most useful shortcut of all. This cool shortcut is also the most beloved to the all anti-mouse users out there.

SHIFT+F6 – This does the reverse of the F6 shortcut.

CTRL+F6 – This switches to the next workbook window when multiple workbook windows are open.

CTRL+SHIFT+$ – This applies the currency format to the selected cells. Great for those times when dealing with monetary data.

CTRL+SHIFT+# – This applies the date format with a default order of day, month, and year.

CTRL+; – This enters the current date in the selected cells.

CTRL+SHIFT+@ – This applies the time format with the default value of hour, minute and AM/PM.

CTRL+SHIFT+: – This enters the current time in the selected cells.

CTRL+` – This alternates between showing the value of a cell and the formula in the worksheet. Great for complex worksheets.

CTRL+D – This uses the fill down command on the selected cells. Fill down copies the content and format of the topmost cell into the cells below.

CTRL+R – This uses the fill right command on the selected cells. Fill right copies the content and format of the leftmost cell to the cells to the right.


Author: Prashant Swami18 Nov 2009 Member Level: Silver   Points : 0

That's a good post.

Useful post.
Keep posting.

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: