Archive for Excel
You are browsing the archives of Excel.
How to Highlight or Remove Duplicates in Excel 2007?
Easy method to delete, remove duplicate cells, columns or rows in Excel. Use conditional Formatting to highlight duplicate cells or unique cells in Excel 2007 from MS Office.
Download ODF Plugin for Office 2007 before SP2
Create files in ODF Format in Office 2007. Read, write, edit, convert and save files in .odt, .ods, .odp in Word, Excel and Powerpoint from Office 2007. Download ODF Plugin for Office 2007.
How to Open Two Excel Files Side by Side in Separate Monitors?
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.
How to Convert Rows to Columns or Columns to Rows in Excel While using Formulas?
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 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
