Archive for MS Office
You are browsing the archives of MS Office.
How to Switch between A1 and R1C1 Reference Style in Excel?
how to change from R1C1 reference style to A1 reference style. change numeric reference of columns to alphabetic reference and vice versa. RC reference of excel from office 2007.
Search the Commands in Office 2007 Ribbon Using Search Commands from Office Labs
How to find the commands or search the commands in Office 2007 – Word, Excel and Powerpoint. Search Commands from Office Labs Project. Download Search Commands. Keyboard Shortcuts for Search Commands.
What are A1 and R1C1 Reference Style in Excel?
What are A1 and R1C1 reference style in Excel and how to use it? Absolute and relative reference using R1C1 reference style. Tutorial and examples of R1C1 reference style and A1 reference style. Using R1C1 reference style in Excel Macros and Formulas
How to do Quick Sum in Excel Using AutoSum and its Keyboard Shortcut?
Using Autosum in Excel to do a quick sum in Excel Sheets. Tips on how to use AutoSum and Keyboard Shortcut for Autosum in Excel 2003 and Excel 2007.
How to View Formulas instead of Values in Excel Cells?
How to show or view formulas in all the cells in Excel instead of the actual values after evaluation. Keyboard Shortcut key to show and reveal all the formulas in the excel sheet. Ctrl + ` to show the formulas in excel from Office 2007
How to use Relative and Absolute References in Excel?
What are relative reference and absolute reference in Excel? Different Cell reference in excel. keyboard Shortcut to insert absolute cell reference. Tutorial on how to use relative and absolute cell reference in Excel from Office 2007
How to Insert Multiple Empty Rows or Columns in Excel?
How to Insert multiple rows or columns in MS excel 2007 using different methods. Using insert copied cells, keyboard shortcut to insert rows and excel VB macro…
