-
![MS Excel Tips – Find Duplicates from 2 columns]( "MS Excel Tips – Find Duplicates from 2 columns")
January 28, 2009 It will be hard sometimes to find the duplicates in a spreadsheet. There is no easy way to do...
Read More
-
![MS Excel Tips and Tricks – Change the Cell format from Text to Number]( "MS Excel Tips and Tricks – Change the Cell format from Text to Number")
December 31, 2008When you use Microsoft Excel, You will sometimes find that the numbers are not calculated properly. This is mainly because...
Read More
-
![MS Excel Tips and Tricks – Remove or Add Fixed Decimal Points]( "MS Excel Tips and Tricks – Remove or Add Fixed Decimal Points")
December 30, 2008Sometimes you will see Microsoft excel sheet adds the decimal points with all the numbers that you enter. You can...
Read More
-
![MS Excel Tips and Tricks – Hide or Unhide scroll bar]( "MS Excel Tips and Tricks – Hide or Unhide scroll bar")
December 29, 2008You can hide the vertical scroll bar or the horizontal scroll bar in any excel work book.
Go to Tools menu
Click...
Read More
-
![MS Excel Tips and Tricks – How to insert Date and Time in Header or Footer]( "MS Excel Tips and Tricks – How to insert Date and Time in Header or Footer")
December 22, 2008 You can insert Custom Headers and Custom Footers in any Microsoft Excel worksheet, so when you print, you will...
Read More
-
![Excel Tips and Tricks Cell Label, Cell Name, Range Name]( "Excel Tips and Tricks Cell Label, Cell Name, Range Name")
December 17, 2008Microsoft Excel worksheets has name for each cells. They start from A1.
These are used to calculate values and for reference...
Read More
-
![Excel Tips and Tricks – Hide Gridlines]( "Excel Tips and Tricks – Hide Gridlines")
December 15, 2008You can hide the excel gridlines by doing the following
Open Microsoft Excel sheet that you want to hide the gridlines
Go...
Read More
-
![MS Excel Tips and Tricks Hide Worksheet(S)]( "MS Excel Tips and Tricks Hide Worksheet(S)")
December 15, 2008You can hide Microsoft Excel worksheet from any work book
Open the Workbook that you want to hide the excel worksheets...
Read More
-
![Ms Excel Tips and Tricks Hide or Unhide Excel workbook]( "Ms Excel Tips and Tricks Hide or Unhide Excel workbook")
December 14, 2008You can hide any Microsoft excel workbook or sheets.
To hide a work book open the work book
Click Window menu
Click hide
The...
Read More
-
![MS-Excel Tips and Tricks – Change the Gridline color]( "MS-Excel Tips and Tricks – Change the Gridline color")
December 14, 2008Microsoft excel gridline are the ones that are around the cell in Grey color. By default excel has the grey...
Read More
-
![MS Excel Work Sheet Tips and Tricks]( "MS Excel Work Sheet Tips and Tricks")
October 23, 2008How to Delete, insert, Organize, Color, group, Move or Copy work Sheets in Microsoft Excel?
Insert Excel Sheet
If you want store...
Read More