Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel training seminar - headers

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - Headers..

excel training seminar - Headers..

ResolvedVersion Standard

Colette has attended:
Excel Introduction course

Headers..

How do I keep headers at the top of each column so that as I scroll down the page they are still visible at the top?

RE: Headers..

Hi Collette

It is known as FREEZE PANES

To use this function, select the row BELOW the the row you want to freeze, and then select WINDOW > FREEZE PANES

Regards

Richard

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.