Dumb question, when I hit (ctrl+shift+down) on column B (data in A) to highlight all rows, my sheet keeps going ALLL the way down to >10,000th cell... how do I make sure it only goes down to my data?

like
Posting as :
works at
You are currently posting as works at

I would suggest doing ctrl+down on column A, moving over to B, and then ctrl+shift+upping. That function only works when there is data in the column you’re moving up and down in

likesmarthelpfulfunny

Good question. The first thing I with all my workbooks is select rows from say 10 after where my data ends to infinity and “hide”. Same thing with columns. This way the sheet is nicely contained!

likesmart

When you want to select an empty set of rows next to a row of data, doing ctrl+down on column A, then selecting up on column B, as PwC1 suggested, is probably most common and convenient. By doing ctrl+down, you fast forward through a blocks of cells (either all empty or all full). Since column B is entirely empty, it will go to the bottom of the sheet. Alternatively, doing a ctrl+shift+end will bring you to the bottom-right most active cell (this is sometimes more convenient when you are tying to get the end of a very long column with lots of random blanks in the data, as ctrl+down will stop at every block of blanks).

likehelpful

Thank you all! I will do the ctrl down column A and then selecting up on column B. 👍👍

like

Ctrl d column a. Right. Ctrl right. Ctrl shift 1
Then build an end row for everything so all your future ctrl downs work fine

like

Keep in mind as mentioned that hiding or doing things with rows and columns outside the scope of your project can slow processing speeds and increase file size

likehelpful

I’ve ran into processing issues when hiding all unused rows/columns as SC1 has suggested. Not sure why but I’ve stopped doing that for a while now.

likehelpful

It sounds like you may need to clear the cells outside your table. Sometimes that can make it process faster

Related Posts

If you find this message, it’s not a mistake and it’s for a reason. I just want to let you know that - I’m proud of you no matter what, for making efforts and never giving up. I’m sending you this with a hug to let you know that the sky is your limit. Keep soaring!

likeupliftingfunny

Where did you buy your ergonomic chair for wfh? Is there a brick and mortar recommended in the city? Need to try it then usual d2c company.

Which company out of bank of america and cgi is good to work for?

like

Haven’t posted a pic of the pack in a while. Hi from Willie, Zuni, and Maria!

Post Photo
likeupliftinghelpfulfunny

Have a super day with ECG tomorrow. For anyone that works at the firm or interviewed there, any tips on what to expect for the excel test and case study? Any insight into the 4 interviews would be great as well!

like

APS Service Territory can enter to win a $500 gift card. enter the drawing, teachers need to fill out an online form athttp://supplymyclass.com. It only takes 1-2 minutes total time to complete.

 

Any opportunity in Gl in .Net position having 5.2 years of IT experience and 3.8 years experience in .net.

like

Anyone doing this consistently? Came across a guy whose wife in a facility and he's paying $12,000/month. Insanity.

like

Anyone have an extra black coffee ticket for tomorrow at Brooklyn Mirage?

like

Best places for bridal jewelry?

like

Anyone got money saving tips for 6flags great adventure? Trying to plan a trip to go on a weekday to avoid needing a flashpass. Any other tips?

like

What is the best place to meet men who wants to get married?😭

like

May not be a great question but curious to hear how many hours people usually spend to prepare for a PgM onsite interview.

like

What’s in your “hospital go bag,” (mums and dads to be)?

like

Any tips for best places to search for estate planning jobs? LinkedIn, other places? I’ll likely need to leave my current associate EP attorney position at a small firm in CA to move to WA (Seattle area) due to my spouse’s new dream job. Nervous about the transition to new state’s law, plus the job search. Wondering if I should broaden my search to other areas of law. Any tips would be greatly appreciated!

Anyone ever experience intrusive thoughts? My long term significant other does and I’m trying to my best to find a way to understand it better. I’ve never experienced it so it is hard for me :(

Hi guys, Is there any clue when Pepsico GBS Hyderabad office will be reopened? Or will there be completely WFH this year? And incase of relocation, how much is the relocation bonus?

like

my current package in ibm is 19.9lpa fixed. How much wipro can give for 8.6years exp?

For those that recently left from consulting firms, more specifically from Boston Consulting Group, McKinsey & Company and Bain & Company, to go to another industry as an EA, would you say it has been a piece of cake or the workload feels the same? Thanks

like

Additional Posts in Excel Genius

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

I did this manually but would there be a way to pivot the dates (day/month) in the rows years in columns with raw data being (date/month/year) needed a visual of same day different year

Post Photo

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

need to do a timeline with lots of information over a long period of time. I wanted to that in Tableau, but partner will not pay license and data is sensitive so I cannot use Tableau public.
Do you have suggestions?
The requirements are the following:
- No online input data upload (so local editing)
- The produced output file must be local and easily exportable and readable
-timeline must be interactive (filter/click/zoom in/out/view detals etc.)
- free

Any kind of help is really appreciated

like

Help this is probably dumb. I have a workbook with 30 tabs. Is there a quick way to separate each in to its own book or should I copy one a time?

like

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

like

How would you create this formula based on picture. In cell C6 I want to return a value ; if (B6 is in column G, and C4 is in column H, then return (formula). Thank you

Post Photo
like

How TF do I attach the SharePoint version of a slide deck in an email? Every time I try to share, it gives me the link in the email body instead of an actual attachment to open in app. PLEASE AND THANK YOU

like

Does anybody have a good resource that would let me link data from QuickBooks Desktop to Excel?

like

How do you jump to the top cell in a column if there are blanks throughout the column? Control arrow just goes to the next blank cell.

like

Are there any great market sizing and business case spreadsheet templates that you guys have come across? I came across this SaaS valuation template in this bowl which was super helpful, but nothing for sizing or business casing. Appreciate any help.

likehelpful

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

Post Photo
like

Really wish my clients didn’t use Google Sheets. This sucks.

like

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

Hey Geniuses,

I’m looking to teach myself how to build financial models and LBOs for some PE interviews. Do you know of any free or reasonably priced resources I could use?

like

Hi,
I am trying to match in a specific row of a different sheet, although I want to use a calculated row value to specify the array to look in, see the photo for the logic I am trying to do… any ideas on how to get this to work?

Post Photo
like

Not Excel related, but any folks in strategy willing to suggest the best and most useful data platform to learn? I’m thinking along the lines of Tableau, Power BI, etc.

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal