Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Remove Hidden Rows And Columns

  1. #1
    Join Date
    12th April 2006
    Posts
    31

    Remove Hidden Rows And Columns

    I have a spreadsheet with various hidden rows and columns that I do not wish the user to have access too as it contains too much detail for their purposes.

    Copy/paste and copy/paste special also copies across the hidden columns and rows so what I need to do is to copy it to a new workbook but then remove the hidden rows and columns and just delete the existing formulas in the cells which total the data and insert a new autosum.

    I wonder if someone could help with the code for deleting hidden rows and columns.

    Thank you

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,714

    Re: Remove Hidden Rows And Columns

    Why not store the not wanted to be seen details on another Worksheet and hide it?

    Why not copy only the shown data via F5 - Special - Visible cells only

  3. #3
    Join Date
    21st October 2006
    Location
    Czech Republic
    Posts
    40

    Re: Remove Hidden Rows And Columns

    Hi

    try this

    Select the data to copy and than press
    F5 - Other (Sorry I have Czech location Excel and so I don't know caption of this button) - choose Visible Cells Only - OK

    and then copy the data and paste into new workbook. I don't understand what you want to do with summations.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    12th April 2006
    Posts
    31

    Re: Remove Hidden Rows And Columns

    Thank you very much, F5 does exactly what I needed.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Rows & Columns Not Hidden When Workbook Shared
    By trebormint in forum EXCEL HELP
    Replies: 5
    Last Post: June 30th, 2012, 02:08
  2. Find & Replace In Hidden Rows or Columns
    By cochese in forum EXCEL HELP
    Replies: 3
    Last Post: March 19th, 2008, 22:24
  3. Prevent Selection on Hidden Rows/Columns
    By richadj4 in forum EXCEL HELP
    Replies: 13
    Last Post: September 21st, 2007, 10:59
  4. copy skipping hidden rows or hidden columns value
    By ilyaskazi in forum EXCEL HELP
    Replies: 4
    Last Post: February 25th, 2006, 17:13
  5. ignore hidden rows or columns during sum
    By aurobless in forum EXCEL HELP
    Replies: 5
    Last Post: April 5th, 2005, 21:28

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno