Open two different Excel files in seperate monitor when using dual monitors. change the settings to open each Excel file as a separate instance so that excel files can be viewed side by side to compare in separate monitors. Excel 2007 option to ignore other applications that use dynamic data exchange.
Tag Archive for 'excel'
Convert or copy rows to columns and columns to rows in Excel 2007 and Excel 2003 with formulas. copy vertical cell contents horizontally in Excel. How to Transpose data using paste special in Excel? How to paste only values 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.
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 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
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 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
Recent Comments