Most Popular Posts

• How to unlock keyboard??
• Insert Excel Spreadsheet into Microsoft Word Document
• Performing Two-Criteria Lookup
• Generating list of contents of any folder
• List Worksheet Names
• How to copy and paste values in filtered data?
• SUM(IF()) array formula
• Sumif array formula OR countif function
• How to find or replace asterisk(*) and question mark(?) in MS excel??
• Indirect Function

Excel Shortcuts

• Custom Right Click Menu
• Alphabetic Series on Excel
• Accessing other worksheets in a workbook faster
• Naming cells in Excel
• Run Command shortcuts
• How to add "My Recent Documents" to the Start Menu?
• Dragging a formula down
• See all Formulas at Once
• Delete Excel chart
• Hide and unhide rows and columns without a mouse
• Mouseless Dragging of the topmost cell to cells below
• Excel keyboard shortcuts List

General Tips

• Save a new worksheet directly in the desired folder
• Choosing your own "Save File" location
• How to unlock keyboard??
• 10 ways to open excel faster
• Excel's Images and Screenshots
• Splitting Large Excel files into smaller parts using Winzip
• Insert Excel Spreadsheet into Microsoft Word Document
• Putting Borders around bunch of non-adjacent Cells at once
• Selecting Multiple Worksheets
• How to sum values in a filtered list???
• Converting Text to Columns in Excel
• Moving between multiple excel Workbooks
• How to get rid off #### entries in excel???
• Avoiding blank cells
• Excel to PDF Converter

MiniStore

Recent Posts

• Custom Right Click Menu
• Reader’s Questions - Performing two-way look up
• How to copy and paste values in filtered data?
• Save a new worksheet directly in the desired folder
• Freezing Formulas

MyBlogLog

Subscribe

Recent Comments

• David Clark: TOTALLY USEFUL. a lot easier than writing CODE
• federico: Thanks for the tip this help me figured out a way to make a list of a karaoke collection the easy ...
• John: The only problem with this method is if your data will be used in a Pivot Table. The Pivot Table wi...
• Nirmala: Good marco. Something that I was trying to figure out for a long time. Thanks. It helped me a lot.. ...
• KRISS: Thank you for filling in one of many gaps in Microsoft's "help" information.
• iceman: This is nice
• judgepax: Thank you for the wonderful macro! No one else seemed to know how to do this, so you just saved me ...
• Riddha: This is cool! Really helped me to move my excel skills a notch up! Thanks!
• malcolm: thank you massivley. that little problem was truley annoying.
• JT: THANK YOU!!!!!!!!!!!!!!!!
• Nicki Soules: Thank you for this information. Sounds like we are not the only computer people that have had this ...
• Daniel: Another method is Data - Text to Columns - Choose Fixed Width you can do more than 2 splits this...

Clever Excel Formulas

• Reader's Questions - Performing two-way look up
• How to copy and paste values in filtered data?
• Freezing Formulas
• Sumif array formula OR countif function
• How to find or replace asterisk(*) and question mark(?) in MS excel??
• Generating list of contents of any folder
• Performing Two-Criteria Lookup
• Formatting the cell as text
• Selecting non-adjacent cells in excel
• Pivot table or countif function???

Logical Excel Formulas

• SUM(IF()) array formula
• Excel frequency function or simple logic??

Excel Macros

• Finding external links
• List Worksheet Names

Excel Functions

• Finding external links
• Indirect Function
• Alphabetic Series on Excel
• Is there any de-concatenate command??
• Changing case in Excel
• Concatenate function
• Highlighting duplicate values in adjacent cells
• Offset function in conjunction with Sumif

Excel Online

• Now share your excel sheets using Microsoft's Office Live Workspace

Excel Formula Bar

• Display separate taskbar button for every open excel workbook
• Compare multiple excel sheets at once