you’re able to also copy data from another location andpaste it in your sheet.
Managing Spreadsheets
you’re able to add many sheets to your Excel workbook.
This is handy for handling projects that require separate spreadsheets.
This adds a spreadsheet to the right of the active one.
This adds a spreadsheet to the left of the active one.
When you add a sheet, it has a default name of Sheet with a number.
So, you’ll see Sheet1, Sheet2, and so on.
To rename a sheet, double-tap the current name or right-click and pick “Rename.”
Then, punch in the new name and press Enter or Return.
To rearrange sheets, select one and drag it left or right to the spot where you want it.
This is a great way to spot certain sheets at a glance or color-code them for specific tasks.
Toremove a sheet, right-click and choose “Delete.”
Select “Delete” to continue or “Cancel” to keep the sheet.
Or, you might decide to remove a column or row you no longer need.
To select a column, hit the column header which is the letter at the top.
To select a row, poke the row header which is the number on the left.
For more, look at our tutorial forinserting multiple rows in Excel.
As you review the list of options, you’ll see examples of how the data will appear.
Pick the format you want, and you’ll see your data update.
you’re free to also choose the style for the number format you use.
go for the small arrow on the bottom right of the Number section in the ribbon.
When the Format Cells box appears, go to the Number tab and select an option on the left.
For example, you canchoose the number of decimal placesand how you want todisplay negative numbers.
After you make your selections, click “OK” to apply them to the value.
You’ll see several options in the Font section of the ribbon.
Font style and size: Use the drop-down boxes at the top to change the font style or size.
you’re able to also use the buttons to the right to increase or decrease the font size.
Border: Use the Border drop-down box to choose the pop in and style for the cell border.
Related:12 Basic Excel Functions Everybody Should Know
Go to the cell where you want to add the calculation.
As an example, we’llsum the cellsB2 through B6, so we pick cell B7.
Head to the Home tab and opt for Sum drop-down box in the Editing section of the ribbon.
You’ll see the basic calculations it’s possible for you to perform.
For our example, we select “Sum.”
You’ll then see Excel highlight the cells it believes you want to calculate.
It also shows youthe functionand formula it’ll use.
Simply press Enter or Return to accept the suggestion and get the result.
Alternatively, you’re free to start by selecting the cells you want to calculate.
Then, choose the calculation from the Sum drop-down box.
As an Excel beginner, these basic tasks should get you off to a great start using the utility.
