The number of columns and rows have been increase in Excel 2010. How large the size of the worksheet? Find out more from our interesting comparison examples!
Archive of posts tagged Microsoft Office
The Secret Of .XLSX File
The new .xlsx file format is actually a ZIP file in disguise. It’s composed of several files that are compressed and then packaged together as a single unit
Adding VBA Macros to the Quick Access Toolbar
Step by step instruction to guide you adding VBA macro as icon in Quick Access Toolbar, QAT.
8 Simple Steps To Setup AutoFill Series
You can create your own series with a custom step value, which determines the numeric difference between each item in the series.
Change Excel’s Default File Location
Excel saves every new workbook in the My Documents folder. Many times it is not practical for many users. Learn how to change the default file location folder.
Tour The New Excel 2007 Ribbon User Interface
In Excel 2007 & Excel 2010, Microsoft no longer loves the menu bar. They have completely abandoned the menu bar and toolbars in favor of new element called Ribbon.
How to Open Workspace Automatically Whenever Excel Launches?
When you know that you’ll be using a particular workspace for some time in your Excel work, you can speed up the process of setting up your work environment by having Excel automatically open the workspace file when you launch the program.
Tips To Make New Excel Ribbon Behave Like Legacy Menu
While there is nothing you can do to bring back the legacy Excel menu and toolbars, you can make the ribbon behave a bit more like a old style menu.
Navigating Workbook | Show and hide Excel Windows
Beginning with Excel 2007, workbook “files” are actually compressed folders. Inside the compressed folders are a number of files that hold all the information about your workbook, including charts, macros, formatting, and the data in its cells.
Three Easy Steps To Work With Smart Tags
You can make your Excel work faster and easier by taking advantage of smart tags. A smart tag is a special icon that appears when you perform certain Excel tasks.