Copyright © 2012 - 2019 AJaGi ® All rights reserved. Not Affiliated with Microsoft Corporation
~ See Latest Blog Post ~
AJaGi~ Articles
Click on Sheet "March".
Notice that it does have the same
text typed onto Sheet "January
Tip No. 1
Add Color to Your Sheet Tabs
Right click on the sheet tab you want to change the color of.
Click on "Tab Color" to display colors.
Click on the color you would like.
(see that purple is selected)
Tips & Things
This is how the tab color appears on the active sheet tab.
(Sheet 1 is active)
This is how the tab color appears when a different sheet is active.
(Sheet 2 is active)
This Ends Tip No. 1!
PAGE CONTENT
~Tips & Things~
Employee / Entrepreneur
Use, Edit & Create
PAGE CONTENT
♦ 1 ♦ The Basic Structure of Spreadsheets
About Spreadsheets
♦1♦ Basic Structure
~Tips & Things~
~Use, Edit & Create~
AJaGi~
About Spreadsheets
♦1♦ Basic Structure
~Use & Create~
~About Spreadsheets~
A spreadsheet file is called a Workbook and a new workbook file usually contains three Worksheets by default. A workbook file could be
thought of like a traditional paper notebook and its worksheets as the paper pages of a paper notebook.
Notice, across the top of the worksheet (page) are the Column Headings (A B C D E F ...) and down the left side of the worksheet are the Row
indicators (1 2 3 4 5 6 . . .). Along the bottom of the workbook are the worksheet tabs indicating that this Workbook contains three sheets,
(Sheet1, Sheet2, Sheet3). You can also see that we are currently on Sheet1.
Recall that sheets are naturally formatted like graph paper and each square on a sheet is referred to as a cell. Cells are identifed by their column
and row notations. So the cell currently selected (notice the black outline) is cell A1. It is also Column 1 and Row 1. If we were to move one cell
to the right, we would be in cell B1 or Column 2, Row 1. If we were to move down one cell (from A1), we would be in cell A2 or Column 1, Row 2.
(After column Z comes AA, AB, AC, AD...) It is highly unlikely that you would ever run out of rows or columns.
Additionally, the worksheets may be likened to sheets of graphing paper as they are sectioned by rows and columns.
This is a spreadsheet sample. Notice the graph paper like layout.
This Ends Use, Edit & Create No. 1
Tips & Things
Click on Sheet "February".
Notice that it does not have the
text placed on Sheet "January
Select sheet "January".
Then hold the Ctrl key & click sheet "March"
Notice that sheets January AND March are now
highlighted as they are now grouped together.
Select sheet "January".
Then type text onto sheet "January"
This is sheet No. 2 in this example.
It is labeled as February.
This Ends Tip No. 2!
♦1♦ Basic Structure
~Use & Create~
About Spreadsheets
PAGE CONTENT
Now click on sheet "February" and notice that this breaks the group link.
Also notice that sheet "February" now has the exact same text in exactly the same location as sheet "January".
~Tips & Things~
While on sheet "January, type text onto sheet "January"
This is sheet No. 3 in this example.
It is labeled as March.
Tip No. 2
Group Non-Adjacent Sheets
Click on sheet "March" and notice that it also now has the exact same text in exactly the same location as sheets "January" and "February".
Sync Data by Grouping Sheets
While on sheet "January" hold the Shift key & click sheet "March"
Notice that sheets January through March are now
highlighted as they are now grouped together.
This is sheet No. 1 in this example.
It is labeled as January.
Click on Sheet "March".
Notice that it does have the same
text typed onto Sheet "January
PAGE CONTENT
About Spreadsheets
♦1♦ Basic Structure
Thanks for Stopping By!
~Tips & Things~
~Use & Create~
Business / Success Quote
~Just For Fun~
~Just For Fun~
~Just For Fun~
~Just For Fun~
~ See Latest Blog Post ~
