How To Set Up A Database In EXCEL Which Is Searchable.

Asked By A Cameron 0 points N/A Posted on - 09/30/2016

Excel helps us to budget, report, forecast etc. It can also act as a spreadsheet database. It includes features like sorting etc. how to set up a database in EXCEL?

• Status: Open
• Question Views: 489
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By R Carlos 10 points N/A #91389

How To Set Up A Database In EXCEL Which Is Searchable.

STEPS TO SET UP A DATABASE:

1) Type the labels in the first row. Each row defines a record.

2) From the top bar select the view tab and go to Freeze Panes item.

3) From the drop-down menu press on Freeze Top Row. This will keep the the header visible even when we scroll down.

4) Type in your information in the rows.

5) Select all the cells in the worksheet.

6) Click on the filter button from the Sort and Filter group.

7) From the drop-down menu select any option as per the operation you want to carry out.

8) Choose from the number or texts Then click OK.

9) From the filter button disable the filtering.

About R Carlos

Questions
15

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/30/2016
• Question Category: MS Excel