Excel Tip! Changing columns and format over multiple sheets

By Patricia Egen • April 8th, 2015

excel tipsI work with Excel so often that I forget that things I do all the time and take for granted may not be widely known or used.  Today is yet another example.  While working on a client spreadsheet I did something that made my client exclaim and stop me mid-stream to show him what I had done.

We were working on multiple sheets in a workbook – actually it was his Paypal transactions and we were preparing sheets for each month.  He had already started the sheets and I was putting in place some automation. However, when he set up the sheets, he had not copied over the header for the first line (each sheet were little mini databases of info).  Also, we needed to hide some of the columns we didn’t want.

What I did was my trick for today’s post.  First I copied into the clipboard the column headers from the first sheet.  Next, at the bottom of the workbook, I highlighted all the spreadsheet tabs by clicking while holding the CTRL key so that all the spreadsheets were “selected.”

Next I moved to the second spreadsheet tab, went to the first line, right clicked and clicked on Insert Copied cells.  Next, I hid the columns I didn’t need, expanded the ones we wanted larger, changed the font to  larger size and then clicked down on the bottom to “deselect” the other spreadsheets.  I then went to each spreadsheet to make sure everything I had done was the same on the other sheets.

You can use the same technique to add in column headers if they were not there in the first place.  Selecting all the tabs at the bottom means that whatever format changes you make will apply to all the selected sheets.

Sometimes, being lazy or very busy makes you learn shortcuts and tricks.  My client said this one little trick was worth the whole consulting day.  Gotta love it.

 

Leave a Comment

« | Home | »

  • Been sent a support request?

    Click here to enter your ticket number: Ticket

  • Our Business

    Our Mission
    Bridging the gap between technology and business processes. Provide quality business consulting, with an emphasis on technology, maintain superior client relationships and enjoy the trust and respect of our clients

  • Us in a nutshell

    Swiftpage
    CRM applications
    Data Conversion
    Custom Programming
    SQL Experts
    Lotus Notes
    Quotewerks
    Stonefield Query
    MS Office Programming
    Business analysis
    Process Workflow
    Social Media and SEO
    Linux, Mainframe
    Been there, done that



  • Facebook Like Us!