How to: Show more sheet-tabs in Excel

Show more sheet-tabs in Excel

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: […]

How to: Create a bulleted list in Excel

Insert a bullet list in MS Word

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 […]

How to: Protect multiple sheets at once

Protect multiple sheets at once

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 […]

User question: How to send this sheet to an e-mail in Excel 2010?

Sent this Sheet

"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. […]

User question: How to delete cells based on content

Select cells based on content, formatting and more...

"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 […]

User question: How to enter the same value on multiple sheets (or in multiple cells at once)

Press control+enter to enter the same value in all selected cells

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 […]

How to: Save several worksheets together in a single new workbook

Select the sheets and right-click on one of them

In addition to my post for yesterday that demonstrated how to save worksheets as separate workbooks, this article will show how how to save several worksheets together in a single new workbook. To save several sheets from your workbook together in a new file, you can do the following in Excel: First select the sheets […]

How do I remove all text before/after a specific character?

Example remove before a certain character

Quite frequently people ask us how to remove all content before or after a certain character. This is easy to do this with Excel's built-in Find and Replace. In this article I'll show you how. Hi! Does your software have a functionality to remove all content BEFORE a symbol in a column? For example: This: […]

How to: Remove or replace line breaks and carrage returns in cells

There are few quick methods to remove the line breaks and carriage returns in cells. By default you might not know an easy and quick way to do this but it is fairly simple, either with just Excel, or with the help of ASAP Utilities. Let's say we have the following example. In this case […]

How to: Check the spelling on multiple or all sheets

The spelling check is complete for the selected sheets

Last week I received the following question: How we can spell check on all sheets. Can you add this in next version/update? Well, you can already do this in Excel. Just select all or multiple sheets and then when you start the Spelling (F7) the spelling check will take place on the selected sheets.

Macro: Keep only ASCII characters 32-127

Last week I received the following question: I get sent Excel files from various vendors. I have to convert these to SAS datasets that get moved to a UNIX system. The SAS datasets can only contain ASCII 32-127. So I need to remove these from the Excel file. You can use the "Text » Advanced […]

Unhide all columns and rows

A short macro that will unhide all columns and rows in order to make all data visible again. Might be useful in some cases. Sub UnhideAllColumnsRows() ' unhide all columns and rows on the current worksheet Cells.EntireColumn.Hidden = False Cells.EntireRow.Hidden = False End Sub If you want more control on which rows and/or columns to […]