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

excel

ResolvedVersion 2003

Julie-Anne has attended:
Excel Advanced course

Excel

how to past information from one sheet to another and keep the same colume row with?

RE: Excel

One thing you can do is select two tabs holding your control key down, from there whatever you do with one worksheet affects the other. So you can type on one and it will appear on both sheets. If you are looking at row width if you change one it will change the other.

Have a go and see if that helps

Tracy

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

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.12 secs.