Question description:
This user has given permission to use the problem statement for this
blog.
How do I get independent Column A and column B's that I can hide rows on Column A without hiding them on Column B?
Solved by X. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
02/03/2018 - 03:35
Hi
Excelchat Expert
02/03/2018 - 03:35
Welcome to GotitPro!
Excelchat Expert
02/03/2018 - 03:35
How may I help you?
User
02/03/2018 - 03:36
I want to hide rows in column A that doesn't affect the rows in Column B
User
02/03/2018 - 03:36
So i hide A1 but B1 still shows
Excelchat Expert
02/03/2018 - 03:37
It is not possible to hide cell only.
Excelchat Expert
02/03/2018 - 03:37
You can hide row or column but not specific cell.
Excelchat Expert
02/03/2018 - 03:38
you can only blank out individual cells. Right-click on a cell or multiple selected cells and then click on Format Cells. On the Number tab, choose Custom at the bottom and enter three semicolons (;;;) without the parentheses into the Type box.
User
02/03/2018 - 03:39
Is there a way to define Column B as an overflow warp?
User
02/03/2018 - 03:39
wrap
Excelchat Expert
02/03/2018 - 03:39
You want overflow warp automatic ?
User
02/03/2018 - 03:40
Basically I have a very long list in Column A with a macros code to hide all 0 or blank cells -- this works fine, but I don't want 4 pages to print, I would like to somehow call the overflow to jump to, lets say B1 for example sake, and stack there
Excelchat Expert
02/03/2018 - 03:41
Sorry, currently we do not provide support in VBA.
User
02/03/2018 - 03:41
It's not VBA related
User
02/03/2018 - 03:41
I can phrase it differently if you like
Excelchat Expert
02/03/2018 - 03:41
You said above "column A with a macros code to hide all 0 or blank cells "
Excelchat Expert
02/03/2018 - 03:42
Sure, please go ahead.
User
02/03/2018 - 03:43
I have a work sheet that with a 4 page long list in Column A, can I define Column B to catch the overflow so that it all fits on 1 page
User
02/03/2018 - 03:43
without using the Print What selection and modifying font sizes
User
02/03/2018 - 03:44
Or copying and inserting cut cells manually
Excelchat Expert
02/03/2018 - 03:45
No you need to have macro code which count number of rows and catch the overflow or you can sent number of rows to display and count it when it above the defined number of rows it will give you a message and you can control it manually.
Excelchat Expert
02/03/2018 - 03:45
can set ** number of rows
Excelchat Expert
02/03/2018 - 03:47
Are you there ?
User
02/03/2018 - 03:47
I am
User
02/03/2018 - 03:47
Just putting that together in my head
Excelchat Expert
02/03/2018 - 03:47
OK
User
02/03/2018 - 03:49
Ok -- So the software itself doesnt have the means to define column B as the automatic overflow catch... and a macro code tell it to move to Column B will get tricky if there are any further edits needed after the catch...
Excelchat Expert
02/03/2018 - 03:49
Right.
User
02/03/2018 - 03:49
So I'd also need a "revert" call to get me back to 0 to edit the list...
User
02/03/2018 - 03:50
I mean, its not terribly inefficient if that's the best I can do with what I'm after
User
02/03/2018 - 03:50
revert everything back to Column A i mean
Excelchat Expert
02/03/2018 - 03:50
Yes bring counter back to zero
User
02/03/2018 - 03:51
I guess it's worth attempting to see how it functions then.
User
02/03/2018 - 03:51
Hopefully I wont pull out all my hair trying it
Excelchat Expert
02/03/2018 - 03:52
Sorry, as we currently not support macro and can not help you.
Excelchat Expert
02/03/2018 - 03:53
Thank you for visiting us!
User
02/03/2018 - 03:53
If you may, which search terms for the overflow catch code should I try
User
02/03/2018 - 03:53
to help narrow it down
Excelchat Expert
02/03/2018 - 03:53
You can set a for loop or Do loop
Excelchat Expert
02/03/2018 - 03:54
I extremely sorry for not in state to help you.
User
02/03/2018 - 03:55
It's ok.
User
02/03/2018 - 03:55
Got me further than I was on my own. So thank you for that
Excelchat Expert
02/03/2018 - 03:55
Thank you!
User
02/03/2018 - 03:55
Ok wish me luck
User
02/03/2018 - 03:55
!
User
02/03/2018 - 03:55
take care!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
