Skip to content

Archive of posts tagged Microsoft

How Big Is A Worksheet in Microsoft Excel 2010

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.