How to set up an basic excel spreadsheet

By vdcohn

Rate: (2 Ratings)

Step by step instructions regarding how to set up an excel spreadsheet.

Flag Article

Instructions

Difficulty: Moderate

Things You’ll Need:

Computer
Excel software

Step1

First you need to come up with an header for your spreadsheet. Go to the top of the spreadsheet and click on bold and click on underline. When you start to write your header it will automatically type in bold and underline your header for you.

Step2

Then go to the bottom of the spreadsheet, use your mouse and hit right click on the icon that says sheet 1 and name that spreadsheet what you would like it to be known as. If you would like to fill in the lines on the spreadsheet so you can type in each box, put your cursor on the box you would like highlighted push the shift button down on the keypad and at the same time hit the arrow keys that goes up, down, or side ways that should highlight your boxes. When you are done highlighting the areas you would like to fill in, then put your cursor anywhere on the spreadsheet and hit right click, when you do that a box should come up, click on format cells, then click on borders, then fill in the lines inside the box how you would like your spreadsheet to look and hit okay. It should automatically fill in your boxes for you.

Step3

If you would like to add numbers up on your spreadsheet. I can give you an example if you have 15 in number 1, 16 in number 2, 18 in number 3, 20 in number 4 and it is in column a. Skip a couple of lines under number 4 and put your cursor on the box so it is highlighted. Go to the top of the spreadsheet where you can type words and put this formula in =sum(a1:a4) and hit enter. If you have done it correctly it should have add 15, 16, 18, and 20 automatically.