WALL STREET PREP EXCEL
WhichpoofpothepofollowingpokeyspoISpoNOTpoapowaypotopotracepoprecedentpocells?po-
poans--CtrlpoAltpo[
Pleaseposelectpothepoanswerpothatpobestpodescribespotheposhortcutpoto
Splitpo(notpofreeze)poanpoexcelposheetpointopojustpotwopopanespo(toppoandpobottom)
Toponavigatepofrompopanepotopopanepo-poans--
1.poWithpothepoactivepocellpoonpoanyporowpobutpoinpocolumnpoA,pohitpoAltpoWpoSpotoposplitpo
thepopanespotopoapotoppoandpobottom.po2.poHitpoF6potopojumppofrompopanepotopopanepo(inp
osomepoversionspoofpoExcelpoyoupowillponeedpotopohitpoF6poseveralpotimespotopogetpofromp
oonepopanepotopothepoother).
YoupoarepoinpocellpoA1poandpostartpoapoformulapobypotypingpo=poinpoapoworksheetpowithpos
plitpotoppoandpobottompopanes.poInpoorderpotopojumppotopothepobottompopanepowhilepowork
ingpoonpothepoformula:po-poans--HitpoF6
IfpoIpowantpotopoaddpothepotitlepo"CompanypoFinancials"poinpocellpoA1poensurepothatpoallpoc
olumnspoarepotheposamepowidthpoacrosspoallpothepoworksheetspoinpomypoworkbook,pohow
powouldpoIpodopothat?po-poans--
1.poGrouppothepowroksheetspobypohittingpoCtrlpoShiftpoandpousepothepoPageUp/
Downpokeyspotoposelectpothepoworksheets.po2.poInpothepoactiveposheetpotypepoinpo"Compa
nypoFinancials"poinpoA1poandpoapplypothepodesiredpowidthpotopoallpocolumnspo3.poRemem
berpotopohitpoCtrlpoPageuppoorpoPagedownpotopomakeposurepothatpofuturepoeditspoonlypoap
plypotopoactiveposheet.
IfpoIpowantpotopoaddpothepotitlepo"CompanypoFinancials"poinpocellpoA1poensurepothatpoallpoc
olumnspoarepotheposamepowidthpoacrosspoallpothepoworksheetspoinpomypoworkbook,pohow
powouldpoIpodopothat?po-poans--
1.poGrouppothepowroksheetspobypohittingpoCtrlpoShiftpoandpousepothepoPageUp/
Downpokeyspotoposelectpothepoworksheets.po2.poInpothepoactiveposheetpotypepoinpo"Compa
nypoFinancials"poinpoA1poandpoapplypothepodesiredpowidthpotopoallpocolumnspo3.poRemem
berpotopohitpoCtrlpoPageuppoorpoPagedownpotopomakeposurepothatpofuturepoeditspoonlypoap
plypotopoactiveposheet.
Whatpoispothepokeyboardposequencepoto
1)poGrouppohighlightedpocolumnspo(butponotpotopohidepogroup)
2)poHidepothepogrouppo(willposhowpoapo+posignpoabovepothepocolumn)
WhichpoofpothepofollowingpokeyspoISpoNOTpoapowaypotopotracepoprecedentpocells?po-
poans--CtrlpoAltpo[
Pleaseposelectpothepoanswerpothatpobestpodescribespotheposhortcutpoto
Splitpo(notpofreeze)poanpoexcelposheetpointopojustpotwopopanespo(toppoandpobottom)
Toponavigatepofrompopanepotopopanepo-poans--
1.poWithpothepoactivepocellpoonpoanyporowpobutpoinpocolumnpoA,pohitpoAltpoWpoSpotoposplitpo
thepopanespotopoapotoppoandpobottom.po2.poHitpoF6potopojumppofrompopanepotopopanepo(inp
osomepoversionspoofpoExcelpoyoupowillponeedpotopohitpoF6poseveralpotimespotopogetpofromp
oonepopanepotopothepoother).
YoupoarepoinpocellpoA1poandpostartpoapoformulapobypotypingpo=poinpoapoworksheetpowithpos
plitpotoppoandpobottompopanes.poInpoorderpotopojumppotopothepobottompopanepowhilepowork
ingpoonpothepoformula:po-poans--HitpoF6
IfpoIpowantpotopoaddpothepotitlepo"CompanypoFinancials"poinpocellpoA1poensurepothatpoallpoc
olumnspoarepotheposamepowidthpoacrosspoallpothepoworksheetspoinpomypoworkbook,pohow
powouldpoIpodopothat?po-poans--
1.poGrouppothepowroksheetspobypohittingpoCtrlpoShiftpoandpousepothepoPageUp/
Downpokeyspotoposelectpothepoworksheets.po2.poInpothepoactiveposheetpotypepoinpo"Compa
nypoFinancials"poinpoA1poandpoapplypothepodesiredpowidthpotopoallpocolumnspo3.poRemem
berpotopohitpoCtrlpoPageuppoorpoPagedownpotopomakeposurepothatpofuturepoeditspoonlypoap
plypotopoactiveposheet.
IfpoIpowantpotopoaddpothepotitlepo"CompanypoFinancials"poinpocellpoA1poensurepothatpoallpoc
olumnspoarepotheposamepowidthpoacrosspoallpothepoworksheetspoinpomypoworkbook,pohow
powouldpoIpodopothat?po-poans--
1.poGrouppothepowroksheetspobypohittingpoCtrlpoShiftpoandpousepothepoPageUp/
Downpokeyspotoposelectpothepoworksheets.po2.poInpothepoactiveposheetpotypepoinpo"Compa
nypoFinancials"poinpoA1poandpoapplypothepodesiredpowidthpotopoallpocolumnspo3.poRemem
berpotopohitpoCtrlpoPageuppoorpoPagedownpotopomakeposurepothatpofuturepoeditspoonlypoap
plypotopoactiveposheet.
Whatpoispothepokeyboardposequencepoto
1)poGrouppohighlightedpocolumnspo(butponotpotopohidepogroup)
2)poHidepothepogrouppo(willposhowpoapo+posignpoabovepothepocolumn)
