Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mikerascally
- Order by date
-
Using range of cells as headers
Hey Great! Thanks. Never thought of going to pagesetup!...need sleep!- mikerascally
- Post #3
- Forum: Microsoft: Office
-
Using range of cells as headers
Hi, How do you select a range of cells to use as the header so that it will automatically appear when printing? Thanks!- mikerascally
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Copy a column and pasting as a row?!
I see. I thought excel would autodetect that it is pasting into another sheet. Ok Thanks alot Geoff!- mikerascally
- Post #5
- Forum: Microsoft: Office
-
Copy a column and pasting as a row?!
No specifics formula or location. Just how do you do the example below using arrays or the $ command Sheet1 Column D (row1) =A1+A2 (row2) =B1+B2 (row3) =C1+C2 Sheet2 Column A Column B Column C (row1){=sheet1!A1+A2} {=sheet1!B1+B2} {=sheet1!C1+C2} It is...- mikerascally
- Post #3
- Forum: Microsoft: Office
-
Copy a column and pasting as a row?!
How do you make a row equal a column while keeping the formula consistent? I tried using the array command (CTRL-SHIFT-ENTER) but all it does is copy the 1st formula. I also tried using the $ commands but they don't work when you go from column to row or vice versa...why?!. Why would Excel limit...- mikerascally
- Thread
- Replies: 10
- Forum: Microsoft: Office
