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
Posting as :
works at
You are currently posting as works at

control g. type in the cell. for example, AH1

likehelpful

yea, i prefer control G. more intuitive. G means "Go To"

like

Ctrl home will also get you to the top left corner of the sheet (and control end for the bottom right of the active sheet)

like

If all columns in the sheet happen to have blanks in the same rows, you could also simply delete these rows using find -> go to special -> blanks.

like

Ctrl A then Ctrl . Will get the 4 corners as well

funny

Ctrl + Fn (function key) + left arrow jumps to top left cell, Ctrl + Fn (function key) + right arrow jumps to bottom right cell

like

Never cared to look for a solution, so would be great if there is one. Page up/page down can cover a lot of ground efficiently in those cases. Can also insert blank column, ctrl up, arrow one over, and ctrl down.

I put an x at the top and bottom in the column to the right and then drag down, if you're looking to drag a formula.

And by drag down I mean highlight the two cells at the top and then Ctrl down once to get to the end

like

Press the right arrow to move to column with either data in every cell or all blanks... then press ctrl up

Related Posts

What are some questions to ask during an interview to understand a company’s UX design maturity and strategy? When design is seen as leading/owning and not just supporting engineering?

like

Hi Everyone what is the pay scale for C2 level in India for Dynamics CRM professional professional.

What are different roles in IQVIA? can someone give the hierarchy?

like

What should I expect for comp as an equity research associate at a $7B buyside long only equity manager? This would be my first ER gig but I do have 6+ yrs of experience at a FoF. Is $150K all-in shooting too high? I don’t want to turn them off with “my expectations”. Thanks in advance!

like

I have worked with Forbes top companies, for-profits, non-profits, & startups. I consider myself a solver of complex & complicated problems requiring mixed method research & novel solutions. This has led to issues in self-referencing title. I’ve been project manager, data engineer, developer, modeler, analysts, principle DB developer, etc. Most of my w2 work has been from offers of 1099 clients so I am usually asked to define my own title. Any T-shaped data people who run into this?

like

After on boarding in Pwc sdc will we get training regarding project or how will it be ? Role SA2

like

Hi Microsoft Fishes are these numbers accurate ??

L58-L59 : Level 1 : 14-16 Lakh + 10-15k worth Stocks
L59-L60 : Level 2 : 16-18 Lakh + 10-15k worth Stocks
L61-L62 : Senior Level 1 : 18-20 Lakh + 10-20k worth Stocks 
L62-L63 : Senior Level 2 : 20-25 Lakh + 10-20k worth Stocks

like

Does W+K NYC have any bad clients? Like pharma or b2b or...?

Hi, everyone! I am extremely passionate about issues such as climate change and gun violence, and how money in politics leads to inaction and disinformation regarding these issues. Does anyone have any insight as to where I should be looking for employment opportunities? Practice areas, the type of organization, traditional vs. non-traditional law jobs? Any help or guidance would be appreciated. I really want to make a change. Thank you!

like

Why my proceed button is disabled in Wipro embark platform for laptop collection mode? My joining date is on 14 Feb tomorrow and my onboarding is not completed yet. The status is showing on embark as onboarding has started. Please reply.

Post Photo
like

If one works as a Graphic Designer but wants to transition into a role as a Visual Designer, is there any reason you can’t just add that to your professional description if you have the requisite work to back it up?

Bastardized Northern Irish Minced Beef Stew (Cont)

Post Photo
like

How does hourly contract lawyering work? I’m on a contract through a recruiting firm before the company hires me directly. My pay is hourly but I get time and a half for over time. I’m currently a policy atty for a think tank and did prosecution before that so I’ve never “billed.” I regularly check and respond to emails on my phone in the evening after work. Do I include that on my timesheet??

like

I received a 3.625% quote by a potential lender. Seems pretty high in today's economy. Thoughts?

like

I just found out that I passed the 4th CPA exam!!! I want to reward myself with (among other things) a nicer laptop bag. I can barely close my car door while carrying a laptop bag, lunch, water bottle, coffee mug, etc. in to work every day. I want to splurge but not too much (probably not more than $200). Can anyone recommend a cute and VERY spacious bag? I’ve been too busy studying on top of everything else I have to do in life to keep track of what is “in.” Any suggestions?

like

Hi All

I am working as SAP FICO consultant at Infosys. I have 4+ years of work experience. Worked on CFIN migration, S/4 , ECC support projects. Can anyone please help me to get referred in CG.

like

Looking to buy a 900k condo in a prime location (3 bedrooms). We have a family income of 210k and have been approved by the bank with 20% downpayment. We have zero debt other than current mortgage but we will sell the property. We really want it, but even though we were approved I feel like its a bit over the top.. anyone has any insight in terms of our ratios?

like

My BGV is showing as completed on ionboard hcl but I haven’t given my form 16, bank statements etc… does that mean BGV is not done properly…

like

AYURVEDA ENTHUSIASTS: I have an extra copy of the Ashtanga Hridayam translation, one of the original Ayurveda scriptures. It's a very well written version and easy to follow for beginners as well. A must-read in my opinion for anyone looking to learn about authentic Ayurveda. DM for details!

like

Additional Posts in Excel Genius

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

Best pdf to excel converter?

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

What's the F4 analogy in Office 365?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

What’s the best way to become a good excel modeller in a short time? Coursera course? Something else?

like

What are your top Excel ninja tricks? Ones that few people know...

like

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

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