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:)

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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.