Remember the “Design” option will enable only if you select any of the cells in your database once you select the Design option, the following options are available for your database. You can change the database design by clicking on the option “Design” highlighted with the red color box in the screenshot. Illustration #2 – Change the Database Format Now your database table looks like the one below. Here we selected the headers also hence I leave it as checked. Untick the checkbox “My table has headers” option if you do not select your data’s headers. Select the entire data and click the insert button in the top left corner.Ĭlick on the table option under the “Insert” menu tab.Ī pop-up box will appear asking for the table address it took that range as the data is already selected. Now it’s time to convert the data into the database table. After applying all the formats, save the table. If a date is available in your data, apply the required format for your date. You can format the cells in your required format, like if you want to show any of your data cells in Bold, then apply the Bold format to the cells. Try not to leave any blanks in the cells. Find the screenshot below I entered a few records for your reference. If you feel all the required columns are added, start inputting your customers’ data under each heading column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |