Hotkey question. Let's say I have 10 rows of data. Added a new column, want to quick fill cells. When I use Ctrl+ down, it select 10k rows because they are all blank. Any better option??

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

Right arrow
Control down arrow
Left arrow
Control shift up arrow
Control D

likesmart

You still got the moves P!

like

Ctrl + Shift + Down with Macabacus

like

Copy your cell you want to drag - use the right most column that has data in it to to ctrl+down to the bottom - then you can paste up in the blank column

like

Sounds like using a table would help you depending on what you’re trying to fill down.

Related Posts

If you are a experienced CAD drafter with experience in environmental remediation, we’re hiring. I’d be happy to discuss the opportunity

Is US Bank Altitude Reserve worth it, if I have CSR?

Seems accurate 😊

Post Photo
funny

Life is so boring 😩

likefunny

Seeing Indians with hatred against the west(due to which Indians have a job ) and Indian media nonstop propogating anti-west/anti-free world hate and supporting brutalities of Putin dictatorship.
Some Indians are even sympathizing with Iran and other radical countries which have carried multiple attack on India and the world.
Never knew Indians had such a despicable thought process.
One thing is clear we are digging our own ditch

like

I’m 32F living in one of the most expensive non-US cities worldwide. I reevaluated my financial plans and would like to get your thoughts and pointers from the wiser fellow here.
Have a 380k usd net worth, and my financial goals are:
1. Buy a first home
2. Children education to top university (single, no kids now. But i know this is what I want someday)
3. Retirement by 55
I don’t actively invest in this period, but keen to know how others do it & choose the right invsmt vehicle for above goals.

like

Tell me your workplace refrigerator drama! I’ll start - We have frozen bean and cheese burritos in the freezer for when you are just so slammed that anything is better than nothing. They’re a last resort that I’ve resorted to several times. Well, one of my colleagues counts the frozen burritos every day.  If one is missing, she will track down the culprit and audit them based on what task they were doing that was so urgent that it required a frozen burrito. Cont’d in comments . . .

funnylike

Anyone here practice SALT? How does it differ from what “regular” tax associates do?

like

I got an offer in accenture. How do i get my project in chennai. All of the projects calls are from bangalore or hyd.Please help

like

Hi fishes I recently joined EY GDS. I was alloted to a project after 2 months.In LEAD I had my counsellor alone. He told need me to include couple of more feed back providers. My designation is senior consultant grade 3. Others in my team are below my grade. I dont know where I can find the feedback providers. Please help

like
like

I got laid off today 🥲 would appreciate anyone who can help refer UX or product designer roles. 🙏

like

This shelter in place is finally starting to have an impact on me. I have a good core group of friends but I am having a hard time sustaining the relationship in this environment. So much alone time to reflect on things in my head and I’m finally starting to feel lonely. Am I the only one feeling this way?

like

Job Security wise how is Accenture doing? I have heard job security is a big question in Accenture. I am about to join Accenture in just 1 week, any heads-up will really help! Thanks!

like

Hi fishes,

Looking for opportunities in manual testing/automation testing for 4 years of experiance in southern India (coimbatore ,chennai , bangalore)
NP - 90 days

like

In which location is Hyderabad office, I've googled it but i found multiple locations.
Also,pls suggest a good pg/society near to Amazon Hyderabad office.

like

Hello... is anyone joining Capgemini (Pune) between 20th Dec to 31st Dec?

Thanks in advance...!!

like

Anyone know of a good newsletter to send out to prospects that you know have money and an advisor? Just want to drip on them...it would have to be regular mail too.

like

At what year mark do you reach senior level?

Additional Posts in Excel Genius

Hello,
How do I randomly pick one name from a list in excel that has identical names?
Example:
Warehouses names
Ana
Ana
Hou
Hou
Aus
Aus

Every name repeats itself several times. But each of them has different lot numbers associated with them. I only need to pick one lot number number from each warehouse randomly. Is there a formula for that in excel?

like

Can anyone recommend a specific video on pivot tables?

like

When you F2 a cell to display cell references. Is there a way to navigate to that cell reference quickly without having to scroll and find the highlighted reference cell?

Thank you

like

I’ve got some lookups to do but inconsistent unique identifiers (names with Bob G01 vs Bob G1). More experienced fish, what’s the best way to perform look ups with this kind of unclean data? Got a few

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

Anyone have a easy formula to turn “2 years 6 months” into 2.5? Thanks!

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

likefunny

I have a spreadsheet that pulls data from rest APIs into power query. Is there anyway to make this sheet work for people on Mac?

likefunny

Best way to learn Spotfire? Just watch YouTube videos?

I’m 26 y/o and working as a sales coordinator (basically an assistant) for 5 national account managers in the investment banking industry. I have a BS in Finance and am series SIE, 7 and 63 licensed. I’m only making $50k a year (before taxes). There are a lot of aspects I enjoy about my job but the pay is not cutting it. Recently, I have found a passion for working with data in excel and I want to try to make a career pivot into business analytics but not sure where to start. Advice?

like

Public schools use Google for everything. So they use Microsoft Office as little as possible. Even Office 365 isn’t used much. I teach an exploratory class to 8th graders for Google docs and sheets since the school tech doesn’t support the educational MS Office 365. I like the MS Office desktop version because it does so much more than 365. I relate how Google does things similar to MS Office but not to the level that Office does.
Do businesses use Google docs, sheets, & the rest for anything?

like

Hi guys!

I need help with something: I recently started using xlookup in excel to automate recurring tasks (accounting) but I have found that my peers and supervisors have difficulties understanding how the numbers are pulled, which makes their understanding of the files difficult.

What would be the best way to convert the result of an xlookup cell to a reference to the found cell?

Is there any way that could be applied to all the xlookups in an excel file?

Thanks in advance!!

like

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

like

Anyone have recommendations for a 5 year forecast model and/or template for a private company? (For a small fintech company)

like

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

like

Does anyone use XLOOKUP over Index Match? Why /why not?

like

Formula to convert the date on the left to the date on the right? I’ve been using text to columns then concatenation but I feel there must be a better way...thoughts? Thanks!

Post Photo
likehelpful

Does anyone know if there is an excel plug-in that links brokerage data (i.e. account info from fidelity/Schwab, etc.) so I can track/analyze on excel?

likefunny

I truly appreciate this group.

Post Photo
likefunny

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

Scan your QR code to download
Fishbowl app on your mobile

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