Blogs about: Excel Tips And Tricks
Featured Blog
Resizing Columns In Excel
Excel will do that for you ! Position the mouse at the right-hand edge of the column header. You’ll know the right spot when the cursor changes to a left-right arrow. Now double-click in that e… more →
Windows XP help
Office 2007 Ribbon Tips
wrote 6 months ago: Scroll through Ribbon Tabs in Office 2007 You can use the scroll wheel on your mouse to scroll from … more →
Customize the Recent Documents List in Office 2007
wrote 6 months ago: The following only applies to Access 2007, Excel 2007, PowerPoint 2007, and Word 2007. Each time you … more →
Excel 2007's Hidden CONVERT Function
wrote 6 months ago: The CONVERT function in Excel 2007 converts a number from one measurement system to another. For exa … more →
.xla (Excel:Add in)
— 2 comments
wrote 11 months ago: Macros are very powerful tool in Excel. One can create all logic and funda in them and use them repe … more →
wrote 1 year ago: Hi! Welcome to my Excel Tips and Tricks blog! Here is where I will post all kinds of things you can … more →
Resizing Columns In Excel
— 1 comment
wrote 1 year ago: Excel will do that for you ! Position the mouse at the right-hand edge of the column header. You … more →
VLookup
— 2 comments
wrote 1 year ago: Hi, Previously I wrote about Pivot table, this time lets explore VLookup as this is also one of the … more →
Remove Duplicate Entries
wrote 1 year ago: Detect and delete duplicate entries in an Excel file. http://www.download.com/3001-20_4-10752056.htm … more →
Delete all the Blank Rows
wrote 1 year ago: Create a macro to delete the Blank Rows in your Excel sheet. Open your Excel spreadsheet that you wi … more →
Delete Hyperlinks
wrote 1 year ago: Delete all Hyperlinks on a sheet in Excel Open your Excel spreadsheet that you wish to remove the hy … more →
Eight Tools in Excel
wrote 1 year ago: 1. Subtotals. When you’ve got reams of data organized by date, it may be hard to see the big p … more →
Excel post 1
wrote 1 year ago: still on project development … more →
The Best Shortcut Keys in Microsoft Excel
wrote 1 year ago: Ctrl+Z Undo Ctrl+C Enter, Ctrl+V Ctrl+X Copy, Paste, Multiple Paste, Cut Ctrl+F, Ctrl+H Find, Find … more →
Excel: Change the font color based on the value in the cell in Excel 2003/XP/2000/97
wrote 1 year ago: To do this, select the cell that you wish to apply the formatting to. In this example, we’ve s … more →
Turn Excel Data and Charts into JPEGs
wrote 1 year ago: Read this from PC MAG. Nice little trick http://www.pcmag.com/article2/0,2817,2269778,00.asp … more →
Shrinking Excel Text
wrote 1 year ago: I use Microsoft Excel 2003 with text in the cells, and the General format applied. when I change th … more →
Excel Color-Coding for the Color-Blind
wrote 2 years ago: There are a couple of macros that you change that can help. They need to reside in the Personal Macr … more →
Make Excel Stop Shooting Blanks
— 2 comments
wrote 3 years ago: It’s always a good idea to choose File | Print Preview before launching an Excel print job. Th … more →
Validating Text Entries
wrote 3 years ago: 1. Select the range of cells. 2. From the Data menu, select Validation. 3. Select the Settings tab. … more →
