Learn A New Skill Learn A New Skill







































































































Contact Us

Color Tabs Ex 1
Color Tabs Ex 2
Color Tabs Ex 3

Copyright © 2012 - 2018  AJaGi ®  All rights reserved.                                                                                                                                                      Not Affiliated with Microsoft Corporation
Color Tabs Ex 5
Color Tabs Ex 4
~ See Latest Blog Post ~
Look Eyes
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~

Thinking Gears
Employee / Entrepreneur
Use, Edit & Create
PAGE CONTENT
♦ 1 ♦  The Basic Structure of Spreadsheets
About Spreadsheets
♦1♦  Basic Structure
~Tips & Things~
~Use, Edit & Create~
HOME
AJaGi~
Intro / AboutLearn A New SkillBLOGProducts & Services

About Spreadsheets
♦1♦  Basic Structure
~Use & Create~
~About Spreadsheets~
Woman at PC



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. 









Home
Home
Paper Notebooks
Sheets of Paper
Additionally, the worksheets may be likened to sheets of graphing paper                                        as they are sectioned by rows and columns.
Spreadsheet Sample
This is a spreadsheet sample.  Notice the graph paper like layout.
Business Man at PC
Figures w/ Laptops
This Ends Use, Edit & Create No. 1
Graph Paper

Look Eyes
Tips & Things
Click on Sheet "February".
Notice that it does not have the
text placed on Sheet "January
March Text Example
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.
Feb no text Example
Jan Non-Adj Example
Jan Sheet Text Ex
Feb Example Sheet
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
Home
Mar Sheet Text Ex
Jan-Mar Ex Sheets
Jan Example Sheet
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~
Jan Type Text Ex
Feb Break Group Ex
Mar Example Sheet
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

Cryptic Puzzle
Smiley Kiss
PAGE CONTENT
About Spreadsheets
♦1♦  Basic Structure
Thanks for Stopping By!
~Tips & Things~
~Use & Create~
Business / Success Quote
~Just For Fun~
Puzzle Pieces
~Just For Fun~
~Just For Fun~
~Just For Fun~
Cryptic Puzzle
~ See Latest Blog Post ~