98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Filling in blanks
Filling in blanks
Resolved · Low Priority · Version 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)
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Validating text entries1. Select the range of cells.
where A1 is the first cell in the range. 6. Click OK. |