what's a row where's the formula bar how
do you zoom in on a worksheet if you're
new to excel or just need a refresher
reviewing how to navigate the
environment and access basic tools can
be very helpful let's start with the
ribbon which is the collection of tools
and features at the top of the screen
the ribbon is divided into tabs like
page layout insert and home to help you
find what you're looking for quickly and
easily also making things easier to find
is the fact that all the commands are
kept together in groups for example the
font group contains everything we need
to work with text including font color
size and more if you look closely at the
upper left corner above the ribbon
you'll find the quick access toolbar
this little toolbar is designed to give
you access to frequently used commands
like save and undo no matter where you
are in the ribbon now let's take a look
at the workbook itself a workbook is
what we call an excel file and each
workbook contains one or more worksheets
also known as spreadsheets kind of like
a book contains many sheets of paper new
workbooks contain three sheets by
default which you can navigate here
every worksheet contains cells that are
divided into columns and rows rows run
from left to right and are identified by
a number for example one to three
columns run from top to bottom and are
identified by a letter such as a B or C
just above the worksheet is a feature
called the name box which tells you the
location or name of the cell you
currently have selected let me show you
what I mean by selecting a random cell
here the one I've selected is right
where column E and row five intersect
making the location or the name of the
cell e5 to the right of the name box is
the formula bar where you can enter text
functions or formulas for the cell you
have selected notice how what I type
here appears in both the formula bar and
my selected cell e5 now I'm going to
switch back to the first sheet in my
workbook so we can take a look at the
tools in the bottom right corner
that includes the horizontal scrollbar
which lets you scroll your worksheet
from left to right so you can see more
columns and below that is the zoom
control use the plus or minus signs or
just click and drag the slider to zoom
in and out finally you have the ability
to change the way you view your
worksheet using the page view buttons
here normal is selected by default page
layout lets you see what your
spreadsheet is going to look like when
you print it and page break shows you an
overview of what you're working on which
is helpful if you're using page breaks
all right now that we know where
everything is we can get into exploring
the Excel environment in detail and
customizing it to fit our needs like
what you just saw rate it add a comment
subscribe to our Channel
the freedom to learn what you want when
you want absolutely free
GCF learn free.org