How To Create A Custom List In Excel 2010
[N.B : The original Excel list post published on 15 July 2011 seems to be inaccessible after we performed some network maintenance, so the contents of the same are reproduced as follows. Isn’t it good to have backups? 🙂 ]
=================================
Microsoft Excel 2010 comes with a very useful feature of defining and using custom lists.
What this means is that say you have a list of...
How To Minimize And Restore Ribbon In Excel 2010
Ribbon in Microsoft Office 2010 provides a logical grouping of commands for various tasks. This whole area can take up more space then previous versions of Office though (2003 and before that).
Here is how to minimize the ribbon area in Excel 2010 :
1. Open Excel and right click any blank space in ribbon area. Select “Minimize the Ribbon”.
2. This will minimize it and will result in more...
How To Change Gridlines Color For Excel 2010 Worksheets
If you are bored of seeing the same old black gridlines in Microsoft Excel 2010 when creating new Excel sheets, then there is no need to keep them that way.
Here is how to change the default gridlines color in Microsoft Excel  :
1. Open Excel and select File > Options.
2. Click on Advanced options and scroll down to the setting “Gridline color”. Change it from the default color of...
How To Create A Custom List In Excel 2010
Microsoft Excel 2010 comes with a very useful feature of defining and using custom lists.
What this means is that say you have a list of items (like computer names or other things) that you keep a track of through spreadsheet, then it becomes possible to make a separate list once and use it as and when required within the Excel spreadsheet.
For example, to make an Excel custom list which is a list...