Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

filling blanks

ResolvedVersion 365

Brooke has attended:
Excel Introduction course

Filling in blanks

I have to export an excel sheet from our system to find the averages of stock.
In the list, some have numbers exports, but I have to manually fill in 0.00 to the rest.
Is there a way to do it just for all blanks in the list to save time?
Thanks

RE: Filling in blanks

Hi Brooke,

Thankyou for your question to the forum.

Yes, you can fill in all the blanks at the same time. Here's how:

1. Select the column with all the blank cells

2. Go to HOME > FIND & SELECT > GO TO SPECIAL

3. Tick where it says 'Blanks' and click OK

4. Enter 0 in the active cell

5. Press Ctrl Enter to auto-populate the other blanks with 0


Hope this helps and please let me know if you need any more support

Kind regards
Martin
(IT Trainer)

RE: Filling in blanks

Thank you for getting back to me on this.
You have probably saved me about a days work every month:)

Excel tip:

Manually wrapping text

To manually wrap text, use the shortcut key Alt+Enter.

To cancel manual text wrapping, simply delete the new line.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.