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 filed under the Microsoft Office category.
Errors In Microsoft Excel Formulas
Formulas may return an error value if a cell that they refer to has an error value. A single error value can make its way to lots of other cells that contain formulas that depend on that cell.
Excel Formula – Any Limitation?
An Excel formula can consist of up to about 8,000 characters.
Hiding A Row Or Column
Hiding a row or column is also useful if you are showing someone a worksheet that contains private or sensitive data that you do not want the person to see.
Why Exporting Excel File To MTH Format?
Keeping track of all webpages files can be a bit of a headache. Fortunately, you can use an easier solution: save everything using a special web archive format.
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.
The Excel Status Bar Gives You More Than Current State
In the status bar, you can see the basic status text such as “Ready”, the view buttons which are useful when you’re preparing a spreadsheet for printing, and the zoom slider bar which lets you enlarge or shrink the current worksheet view
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.