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!
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.
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.
Pinning Application Shortcut To The Windows Start Menu
The fast method to run your application is to launch it from the Start Menu. Learn how to pin your frequent use application to Windows Start Menu quickly
What Can You Customize In MS Office Ribbon And Quick Access Toolbar
How to customize the new Ms Office 2010 GUI? There are many options that you can customize in Ribbon and Quick Access Toolbar?
Show only columns and rows you interested
Tips to prevent certain information from being seen in excel. How to hide or unhide columns or rows so that it simplify the spreadsheet view area when you are working on a large worksheet. This is alternative trick if you dont have a big screen or monitor.
Modify worksheet gridlines for better appearance
Avoid confusing gridlines for excel online forms and presentations with embedded charts and assign new color to gridlines for easier to read excel worksheets
Customize number of worksheets in a workbook
if you find yourself having to manually add new sheets to many of the new workbooks you start, you should probably modify the default number of sheets that Excel adds to all new workbooks
Switching In and Out of Full Screen View in Excel
Learn how to switch in and out of Full Screen view, Controlling the Excel display screen includes not only hiding unwanted toolbars that surround the worksheet but also modifying the sheet’s look and feel.
Framework design guideline
Book review for Framework Design Guidelines: Conventions, Idioms, and Patterns for Reusable .NET Libraries. Find out what you can take away from this book. This is a very good book for programmer, software architect or even project managers.