Excel tips
Althoug this website is merely about ASAP Utilities we've put together some useful tips and links to great websites.Shortcuts
Shortcuts (definition) allow you to perform tasks without having to go to the Excel menu and you can keep you fingers on your keyboard. If you have good knowledge of the shorcuts it will definitely speed up your work and enhance your productivity.Excel tips from weblogs
There are a few great (web)blogs (definition) that frequently share Excel tips and tricks or discuss common problems.Excel tips (old)
- Help, my columns are displayed backwards (2007-01-03)
- Inserting multiple rows at once: the Excel way and the easy way (2006-11-13)
- How can I split the first and last name? (2006-10-31)
- How to change the font size on the sheet tabs (2006-10-30)
- Get the date from a weeknumber (2003-02-25)
- Turn off the "Save as" function: save with the current file name only. (2002-03-17)
- Insert filename in a cell (2002-02-06)
- Getting the processor speed (2002-01-13)
- Improve the speed of your macro's (2001-09-27)
- Align currency symbols to the left (2001-09-10)
- Create a log file (2001-09-06)
- Setting a reference to the VBA Extensibility library (2001-09-06)
- Close multiple files at once (2001-09-05)
- Decide what an INPUTBOX is supposed to return (2001-09-05)
- Disable cut, copy and paste (2001-09-05)
- Drawing aids (2001-09-05)
- Entering the same value or formula in many cells (2001-09-05)
- Excel 2000 limitations/specifications (2001-09-05)
- Excel's startup options (commandline) (2001-09-05)
- Get the windows directory (2001-09-05)
- Making a linked picture of a cell range (2001-09-05)
- Replace Excel's default titlebar (2001-09-05)
- Show the progress of your macro's (2001-09-05)
- Start an application from Excel and wait until it is finished (2001-09-05)
- What is an Add In? (2001-09-05)
- Write data to a textfile (2001-09-05)
- Check if a directory exists (2001-06-09)
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years