Fill blank cells in a list\database

 

 

Fill Blank Cells in a list\Database

Many times when importing data in excel or exporting report from other software in excel format, the database or list when seen in excel, have cells down below that have same headings or subheadings, are left blank for the sake of easier readability as per above screenshot.
 
However this creates a difficulty when such lists are required to be Autofiltered or sorted or subtotaled. To fill the cells down below with the subheadings of the cells above them, we many times copy & paste to fill blank cells from above cells which is a tedious & time taking job.

To quickly do this job do the following:

1.    Select the list\Database.

2.    Click Menu\Edit\ G <Go to..>.

3.    In the [Go To] dialogue box that appears, click the ‘Special’ button.

4.    In the [Special] dialogue box, select ‘blanks’.
       This will highlight only the blank cells in the list, with focus on the 1st blank cell.

5.    In the 1st blank cell, i.e. the cell with the focus, enter the formula =A2
    and press CTRL+ENTER.

6.    As a result, the blank cells down below get filled up with the subheadings immediately above them.

7.    To remove formula again select all this columns(we just fill with formula), Copy & paste special to Value.


 

Exshail Software
 

Replies (2)

NICE

THANKS FOR SHARIN

CHEERS

nice,,,,,

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details