How come an empty column and row are usually added to the top left of the spreadsheet? Is it for navigation purposes?

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

You want data to start in A1? What are we savages.

likefunny

Hunger Games

Do you also make Word and PowerPoint documents with no margins?

likefunny

It’s a nonsense people like to do. As if you started all your Word documents with a blank line. There are already margins implemented for export purposes, and leaving first line and row empty just messes up your export..

like

It’s just aesthetically pleasing. I feel more comfortable adding more columns in between A:B than I do creating a new A

like

Because it looks ugly if you dont

like

You can also conveniently use the empty column on the left as a means to zoom to the top of the sheet with CTRL+UpArrow.

like

Oh wow there is actually a home button. Thnx learned something new

likefunny

Helps with screen grabs 🤷🏼‍♀️

like

Looks better

like

With long spreadsheets with multiple sections that I don't want to spread between tabs I use this column to annotate with an x the start of the new section. Then Ctrl-arrow to move up and down between sections easily.

like

Mine is not to wonder why .... or some shit like that.

likefunny

Bc I am too lazy to look at the column letter so I use the blank column to easily know that I am at the beginning of it...also idk I just think it looks better imo. I also don't like freeze panes so there's that.

like

I use Column A for the lettering for notes (a, b, c, etc). The note itself starts in column B. So my initial setup almost will always include a smaller column A (width of 2).

like

Related Posts

Anyone else get frustrated when the partner brags about their billable hour amount for the month? Like congrats, you get to bill .2 for each piece of mail. You also get .2 for every letter your secretary types up as a "form letter" you never even look at. As an Associate, I don't get those easy/automatic hours.

like

Any1 knows the levels in Siemens advanta means.
Like what levels are PM10, PM09, PM08

like

What will be in hand?
80c - 1.5 lacs annual
Nps - 50k annual
80d - 10k annual
Rent - 15k monthly

YOE 4.4, c++, linux, qnx, automotive, ADAS

Post Photo
like

Should I open an IRA? 25m net worth ~$80k
- 401k: $30k
- robinhood: $20k (+60% all time 😎)
- cash: $25k
- random stuff like bitcoin/robos: $5k

Worked in consulting for two years > startup (laid off) > will be interning at a growth equity/VC fund starting July 6. Comp is variable, could be $70-$200

likehelpful

I'm a long-time Houstonian who's been away for 7 years and is finally coming back for a visit!

Looking for new interesting or unique places to go. I like anything with a gimmick.

Old favorites include the Bookstop that was once a movie theater (closed years ago), Hobbit Cafe, 59 Diner, Treebeards, Phoenicia Market, the Angelika Theatre 😢.

I'm especially looking for:

- a good Tex-Mex rec (my old fave didn't survive 2020)
- unique bookstores
- anything else weird or special! Surprise me 😃

like

Hi fishers,
I need 15 likes to unlock dm. Please help. Thanks in advance:)

likesmart

Any program recommendations for building decks for clients? Indesign is obviously the best IMO, but I’ve found it difficult for clients who don’t have a design background and want to make changes in the future. I feel keynote is a nightmare...wondering if I’m alone in this sentiment lol. It’s so challenging to layer things/ mask photos/ build custom type paths etc. having trouble finding a good alternative and would appreciate any suggestions!!

like

Anybody exit big-law to run for political office? Did you win? If you lost, were you able to return to your firm?

like

Wipro walo, I have joined on last month, 11th July. I am working in South African shift timings. I am entitled to get Rs 2500 per month as shift allowance, but I didn't get it for last month. On speaking to one of our senior members, he said shift assignment only takes place between 1st to 10th of every month. So it will be assigned this month and will also receive last month shift allowance pay as arrear. Is this true ? Where can I check whether my manager has assigned me a shift or not ?

Where are all the cute lawyers 😍😛

like

Hey! Question for SDRs and AEs. What tools do you use to communicate with your prospects and customers other than email and LinkedIn?

like

Does anyone know how long the hirevue videos last for Goldman Sachs? Because when I did it I was very much a beginner and if I do it now I can do it much better. I just don’t want my beginner side to be looked at when I am much more advanced in my talking and technical skills. I know JP Morgan the hirevue makes you do new videos every 6 months

like

Hi guys can you please let me know how to get interview calls with 90 days notice period? Till now I have worked with 2 companies which had 1 month notice so no issues

like

Best site to for watching French Open?

like

Amazon is making me mentally ill. Joined here few months ago.😤

like

Turnover in analytics and research groups seem common but lately it has seemed higher than normal. Anyone else experiencing this at their agency?

like

Hi all,

CPA here trying to get into this space. I have about 4 YOE in Audit in small to midsized firm in NYC. Wondering if anyone can help me out? Should I look to sit for the FSA exams in the Fall?

Also been going through the self learning modules in TCFD knowledge hub.

Thanks!

like

Can anyone provide a link or resources for best recommended resume templates for product managers trying to get into FAANG companies? Thank you!! 🙏🙏

like

What is the benefit of investing in short term stocks (less than 1 year)? Let’s say I’m investing in leveraged oil stocks. Given the short term tax and all the tax reporting, is it worth it?

like

Is it worth hitting Bicester village? Don’t have a lot to shop. Do the stores (gucci, Burberry, likes) get popular retail store items. I’m only looking to get 3/5 pieces. Will be 12 days in London and currently have 2 days with nothing planned. It’s 1.5 hours one way from my hotel.
Could the time be better used to maybe visit Cotswold or York or some other places?

like

Additional Posts in Excel Genius

Anyone have any resources for improving your skills building valuation models for the purpose of CDDs in excel? I’m moving to a new firm and my old one often had our offshore team build out the majority of our valuation models. Now I’m going to be responsible and I want to prep before I onboard.

like

What's the F4 analogy in Office 365?

like

Does EY’s version of excel have Xlookup? I don’t see it

like

Problem:
There is a table. Column A:D are mapped to column E with unique records. In a new column (Q), there is a list of values that that contain any randomized value from Columns A:D. What is the syntax to map Column Q to column E?

Is using INDEX/MATCH the right direction?

like

Can somebody help me with the IF formula here please? I want to match Column K and Column O with No as the select values. I’ve tried =IF(K6=O6=“No”, ”match”) but it didn’t work. Thanks in advance for your help!

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

I’m copying a report into workbook but the columns don’t line up to the report is there something I can do like to make it if this column name copy here. Not sure if this makes sense. I just fell like it really manual and there has to be an easier way

like

Hi! I’ve got a number thats 6 digits and I’d like to make this 4. However, everytime I do my beginning and ending zeros disappear. Any suggestions? Or how do I shorten to 4 and keep zeros

like

Looking to expand my Excel skills by learning Power Query/Power Pivot & VBA & then expand my learning towards certain programming languages (not Excel related).

I currently have access to LinkedIn Learning, but curious about Udemy and Coursera. I know about the differences between them, but content-wise, anyone have a better experience with one over the other out of three? Other recommendations?

likehelpful

My data tables are consistently not calculating all the values which I have encircled. The values are not increasing with the multiple. Could someone help advise

Post Photo
like

I am running a macro that uses "Application.FileDialog(MsoFileDialogType.msoFileDialogFilePicker)" to select a single workbook file and then open the selected workbook.

Cell A1 on Sheet1 of the workbook that is running the macro contains sheet names that can be selected from a drop-down list. I want to be able to use the sheet name that is in cell A1 to select that sheet in the newly opened workbook.

It's probably something simple, but I can't seem to get it to work. Any ideas?

like

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

like

How do you add this to a worksheet? The extension button on the side of the worksheet see below

Post Photo
like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

How do you create a lagged time series in excel? Lag of order 1 and 2

like

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

like

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
like

I have a huge (12,000 plus row) healthcare dataset. Each line is an individual procedure and the date that it happened, per patient. I want to figure out the times each patient came in for one procedure per date or more than one. Can someone remind me how I can best do this?

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

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