QUESTIONS AND ANSWERS
Which44of44the44following44keys44IS44NOT44a44way44to44trace44precedent44cells?44-
44answer--Ctrl44Alt44[
Please44select44the44answer44that44best44describes44the44shortcut44to
Split44(not44freeze)44an44excel44sheet44into44just44two44panes44(top44and44bottom)
To44navigate44from44pane44to44pane44-44answer--
1.44With44the44active44cell44on44any44row44but44in44column44A,44hit44Alt44W44S44to44split44
the44panes44to44a44top44and44bottom.442.44Hit44F644to44jump44from44pane44to44pane44(in4
4some44versions44of44Excel44you44will44need44to44hit44F644several44times44to44get44from4
4one44pane44to44the44other).
You44are44in44cell44A144and44start44a44formula44by44typing44=44in44a44worksheet44with44s
plit44top44and44bottom44panes.44In44order44to44jump44to44the44bottom44pane44while44work
ing44on44the44formula:44-44answer--Hit44F6
If44I44want44to44add44the44title44"Company44Financials"44in44cell44A144ensure44that44all44c
olumns44are44the44same44width44across44all44the44worksheets44in44my44workbook,44how
44would44I44do44that?44-44answer--
1.44Group44the44wroksheets44by44hitting44Ctrl44Shift44and44use44the44PageUp/
Down44keys44to44select44the44worksheets.442.44In44the44active44sheet44type44in44"Compa
ny44Financials"44in44A144and44apply44the44desired44width44to44all44columns443.44Remem
ber44to44hit44Ctrl44Pageup44or44Pagedown44to44make44sure44that44future44edits44only44ap
ply44to44active44sheet.
If44I44want44to44add44the44title44"Company44Financials"44in44cell44A144ensure44that44all44c
olumns44are44the44same44width44across44all44the44worksheets44in44my44workbook,44how
44would44I44do44that?44-44answer--
1.44Group44the44wroksheets44by44hitting44Ctrl44Shift44and44use44the44PageUp/
Down44keys44to44select44the44worksheets.442.44In44the44active44sheet44type44in44"Compa
ny44Financials"44in44A144and44apply44the44desired44width44to44all44columns443.44Remem
ber44to44hit44Ctrl44Pageup44or44Pagedown44to44make44sure44that44future44edits44only44ap
ply44to44active44sheet.
What44is44the44keyboard44sequence44to
1)44Group44highlighted44columns44(but44not44to44hide44group)