Can anyone help me with margins when printing in excel? No matter how hard I try or what I look up, I can’t seem to get rid of white space on the left and bottom when I’m printing.

I’ve tried putting everything margin setting to “0” already and manually adjusting in the print view.

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

Its just on the bottom and the left side? I think I would have to see the document but usually if you set it to 0 that should clear up the problem. You could also try printing it to fit to the paper.

like

Ctrl+P, last option is scaling, select “fit sheet on one page”. This option might work for you unless you have a very large worksheet, in which case your info will be printed in a very small font.
More tips: Excel Tips & Tricks on Amazon. Page 39

Related Posts

For a top Producer of 3 years, is it appropriate to now ask for a raise in my base pay? Base was 42,500 when I started, but now inflation + 2 children later the base pay barely gets me by. Any thoughts are greatly appreciated!

like

Can anyone anyone help with a salary range for a senior E&S UW. 5 years of experience. Interviewing but don’t want to sell short for my salary expectations.

like

I have 3 years experience being an account manager in a large brokerage. I got promoted to be a supervisor to a small team of account managers and started at $77k and have now increased to $83k 6 months later. Does this sound fair based on my 4 years experience in the field or am I underselling myself?

like

International tax manager looking to move to industry in Bay Area or remote. JD background. I’ve been seeing that job postings for “managers” in industry ask for 8 years - I have 4. Is this normal? Advice on applying? Also what to expect for comp?

like

1.What are different band levels in LTI?
2.Is senior specialist level above the manager level in terms of payscale/destination?
3.What does working in salesforce vertical looks like & onshore opp. for US visa holders?
4.Avg hike / variable pay per year?
5.What is the notice period in LTI?
6.Any hidden components included in salary that can be avoided or restructed before joining?
7.What can be avg hike for 9 yrs of Exp in senior specialist track?

Thanks in advance,it will cover most of the queries in the group!

like

In need of advice! I’m 25 years old & 2 years into a niche field of civil litigation. I’m not receiving the support that I want from the Partner I work with and have applied and received 2 other offers:
Offer 1: 135k and 10k sign on bonus to work at a small firm that doesn’t require any overtime
Offer 2: 115k, a woman’s startup with a partner that is retiring in 5ish years. She is starting the company in Jan & I would be her only employee. Great opportunity for growth & learning but risky (cont

like

Hey Guys

Can someone from
Citi Help me out in referral

like

Welcome to the 30s and 40s singles bowl! Here’s to hoping the posts in this bowl are a bit more mature. Relying on the honor system here, try not to lie about your age.

like

Is anyone know why the wipro extending joining date ? Is it safe to wait till the extended date.?

like
like

Anyone here a Product Mgr at Cisco? Would like to connect to discuss the hiring process, and get some pointers towards prep

like

Would you recommend Decode and Conquer as good book for PM interview prep? I’ve seen there’s a new version out

like

What is starting salary of RedTeam Consultant at FireEye in Bengaluru, India?

like

Hey there i got an offer from UNESCO paris as an financial budget monitor intern( in admin department) , while knowing that i like the life in Sweden better than in Paris as an outsider. (i don't speak French) can anyone tell me if it is a good opportunity? Or is it better to stay in Sweden and do ny current intern to be a consultant?

I’m looking to take some certificate classes. Can anyone point me in the right direction for affordable online classes?

like

Should I be concerned about abusing adderell? I was depressed/lacking motivation and needed to get some deals done and my hours up ASAP. Convinced my doctor I had ADHD, so I now have a legal prescription. I feel so much better, and am getting so much accomplished. No judgement please. We all know this is a high stress, high pressure environment.

like

Partners - what was the most stressful year of your career? The year before you made partner? Your first year of partnership? The year(s) you or your partner gave birth?

like

Is chrome river not working for anyone else? I can’t upload images for some reason

like

Know this is a long shot, but if I’m counseled out of one MBB, what are the chances I could get an equivalent job at another? And if not another MBB, thinking that a T2 or B4 could be possible? I’m not even sure I want to stay in consulting, but also feel like I didn’t get a fair shot at it

like

Additional Posts in Excel Genius

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Any book recommendations on excel modeling for real world business applications?

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

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