Filed under: ASAP Utilities, How to, how to with ASAP Utilities on May 15th, 2012 by Bastien | 1 Comment »
When you work with a workbook that includes many sheets, you probably want to see as many of them as possible.
One way to do this, is by dragging the 'slider' from the horizontal scroll-bar to the right.
That will decrease the size of the horizontal scroll-bar and give more space to show the sheet-tabs:
Other tips to be able to show more sheets
- Use short sheet names
- Use a high-resolution monitor. (I have a 24" monitor with a 1920x1200 resolution)
This is in general a good tip when you use Excel a lot because it just works easier when you can see more of your information and modeling without having to scroll.
- Hide sheets that don't need to be read or changed. That way they won't take space.
- Decrease the size of the font used in the tabs. This is a general Windows setting.
More general tips
- Change the order of the sheets so that the sheets that you use the most are listed at the left and thus are visible.
- Sort the sheets so that you can easily find the one you're looking for. You can automatically sort the sheets via ASAP Utilities » Sheets » Sort all sheets...
- Right-click on the "sheet navigation controls" |< < > >| to get Excel's popup that shows all sheets.
- Use ASAP Utilities » Vision Control... to get a list of all sheets in your workbook and quickly navigate to them (and see their settings).
- Create an index page with links to all sheets. Also called "table of contents" (TOC). ASAP Utilities can do this for you.
- Use shortcuts: Control+PageUp to go to the previous sheet, Control+PageDown to go to the next sheet. When you do this while holding the Shift-key you can select multiple adjacent sheets.
Show the tabs on multiple rows? Unfortunately not.
A question many people have asked me and you see asked on the Internet is if it is possible to list multiple rows of worksheet tabs at the bottom in Excel.
Unfortunately that is not possible in Excel or via a macro or add-in (for as far as we know). However the above tips should certainly help.
More tips?
Do you have more tips? Then please share them by leaving a comment.
Filed under: ASAP Utilities, How to, how to with ASAP Utilities on May 15th, 2012 by Bastien | 1 Comment »
Filed under: ASAP Utilities on April 5th, 2012 by Bastien | 4 Comments »
The new pre-release of ASAP Utilities is now available:
Pre-release version 4.8.1, April 2012
Oh, and we looooove Twitter and especially that people share their enthusiasm! Thank you!
Filed under: ASAP Utilities on April 5th, 2012 by Bastien | 4 Comments »
Filed under: General, How to on March 9th, 2012 by Bastien | 3 Comments »
Unlike Word, Excel doesn't have a similar option to insert a bulleted list.
However, you can easily create a similar list in Excel by using a so called "custom number format".
That might sound a bit difficult but it really isn't.
- Just select the list and right-click on any cell in your selection:
Then choose "Format Cells..."
- Now choose "Custom" in the number tab.
In the Type box, enter the symbol or character that you want, followed by a space and the at sign (@)
To insert the bullet points you can use Alt+0149 (type 0149 on the numeric keypad)
or copy it from here: • @
This is an example:
- Any text that you type in cells that are formatted with this new custom format will have the bullet applied to them:
Alternative, edit all cells at once
If you don't want to use the customer number formatting but really insert the bullet or any other character into the cells, then you can use the following tool to quickly do this on all cells at once:
ASAP Utilities » Fill » Insert before and/or after each cell in your selection...
Download example workbook
Example workbook: Example bulleted list.xls
More information and resources
http://support.microsoft.com/kb/323567
http://blogs.office.com/b/microsoft-excel/archive/2010/10/19/create-a-bulleted-list-in-a-cell.aspx
Filed under: General, How to on March 9th, 2012 by Bastien | 3 Comments »
Filed under: ASAP Utilities on January 25th, 2012 by Bastien | Comments Off
Huge speed improvement in the "Select » Select cells based on content, formatting and more..." utility due to a new developed algorithm.
The utility now works much much faster with large data-sets too.
Now available for download
Filed under: ASAP Utilities on January 25th, 2012 by Bastien | Comments Off
Filed under: ASAP Utilities, How to, how to with ASAP Utilities on January 13th, 2012 by Bastien | Comments Off
The built in method of Excel allows you to only protect one sheet at a time. If you want to protect multiple sheets in Excel you have to protect them one by one. This can take a long time if you have many sheets and even might result in accidentally forgetting one.
With this tool protecting your sheets is much easier en furthermore a lot faster:
ASAP Utilities » Sheets » Protect multiple sheets at once...
Filed under: ASAP Utilities, How to, how to with ASAP Utilities on January 13th, 2012 by Bastien | Comments Off
Filed under: ASAP Utilities on January 6th, 2012 by Bastien | Comments Off
First of all: Happy new year!
I wish you all the best, and less time in Excel and more time doing fun stuff like spending time with friends and family, taking long walks on the beach, swimming with your kids, riding your mountainbike, taking photographs, go geocaching, travel or whatever it is you 'd like to do.
The pre-release of the new version of ASAP Utilities is now available.
Filed under: ASAP Utilities on January 6th, 2012 by Bastien | Comments Off
Filed under: General on December 23rd, 2011 by Bastien | Comments Off
Happy Holidays and Merry Christmas!
Lots of love and happiness for you, your co-workers, family and friends.
And if you don't celebrate Christmas, have a great weekend!
Filed under: General on December 23rd, 2011 by Bastien | Comments Off
Filed under: General, How to on November 21st, 2011 by Bastien | Comments Off
"Hi Bastien,
I am a great admirer of you ASAP-utilities. Great work.
I have a little problem with Excel 2010, that I am hoping that you might have a solution to.
We have just switched over to the excel-2010 from excel-2003. In the 2003 there was a button to send this sheet to an e-mail.
I can’t do that in the 2010, and I have asked many “experts” and they are all saying that it’s not possible in the 2010.
Do you know a way to solve this or get my button back??"
Yes, don't worry, you can still do this in Excel 2010.
Microsoft hasn't removed it but just made it difficult to find (for no apparent reason)
Ron de Bruin, an expert on Excel, has written an excellent article on how to bring it back:
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm
In Excel 2002-2010 you have a option in the User Interface to mail a selection or worksheet in the body of the mail.
Excel 2002-2003 : You find this button next to the save icon in the Standard toolbar or use File>Send to>mail recipient.
Excel 2007-2010 : Microsoft hide it (It is not in the Office button>Send menu or in BackStage View)
But you can add this option to the QAT (Quick Access Toolbar)
- Office Button/File > Excel Options
- Customize (or Quick Access Toolbar in Excel 2010)
- Choose "Commands Not in the Ribbon" in the "Choose Commands from" list
- Select the command "Send to Mail Recipient"
- Add
- OK
Filed under: General, How to on November 21st, 2011 by Bastien | Comments Off
Filed under: ASAP Utilities, How to, how to with ASAP Utilities on November 18th, 2011 by Bastien | Comments Off
"Hi!
I couldn't find the following function in ASAP Utilities:
Delete cells based on content. Ex.: I would like to delete all cells (content) which is less than 3, greater than 100…. Would be nice when working with statistics."
Well, you can already do this in ASAP Utilities, but with an additional step.
First you can select those cells with the following tool, and then just hit the DEL key:
Select » Select cells based on content, formatting and more...
Filed under: ASAP Utilities, How to, how to with ASAP Utilities on November 18th, 2011 by Bastien | Comments Off
Filed under: ASAP Utilities, General, How to, how to with ASAP Utilities on November 16th, 2011 by Bastien | Comments Off
Today we received the following email:
Let me start by saying how wonderful I think your program is. It saves me a lot of time.
I just created 100 sheets and named them from a list using ASAP -great!
I then inserted the name of each sheet into a cell within the sheet using ASAP -fantastic!
Here's my problem:
In sheet one, I'd like to enter a formula in A2 and be able to copy it to A2 in the other 99 sheets. Can ASAP help me with this?
I'd also like to be able to do this with a value in A3.
Well, this can already be done with just Excel.
If you want to enter the same formula on all 100 sheets, just select all the sheets and then enter the formula in A2... However, instead of pressing Enter at the end, press Control+Enter at the end. That way the formula will be entered in all selected cells, also the same cell-address on the other selected sheets.
You can also use this Ctrl+Enter to enter the same value in all selected cells on the same sheet.
Read more...
Filed under: ASAP Utilities, General, How to, how to with ASAP Utilities on November 16th, 2011 by Bastien | Comments Off
