Excel?


  1. Martin Dendev
    Posts : 170
    Windows 7 Home Premium 32 bit
       New #1

    Excel?


    Hi,
    Maybe a bit of off-forum, but how do you make that column A en B show on every sheet (not printed) of my excel workbook?

    I got Name and First Name, and I want to have that shown at every new sheet I make without having it to copy each time and when I change something at my first sheet, the two columns get changed at every sheet.

    I hope I'm clear...

    Martin
      My Computer
    Quote Quote

  3. pparks1
    Posts : 7,878
    Windows 7 Ultimate x64
       New #2

    It's called Freeze Panes.

    Highlight A and B. On Excel 2007/2010 the freeze panes button on the ribbon should be on the View Tab. Choose Freeze Panes.
      My Computer
    Quote Quote

 

  Related Discussions
The “problem” I’m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb. I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit. The W700 has Office 2007 and theW541 has Office 2013. Both versions ofExcel are 32 bit as far as I...
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 23:15.
Find Us