After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

View -> Page Break Preview

Shortcut: Alt+W+I

like

Related Posts

I am joining IBM 7A Band as senior Application developer.How much time it takes to get band 7B. I wanted to know about band progression and % increment they give in that.IBM

like

I currently work in risk assurance and have a strong background in data analytics. I’m not really sure what my options are looking forward or where to look. Any ideas?

like

Coronavirus and health: has your alcohol consumption gone up during the pandemic? This pandemic had encouraged me to quit for good now.

like

Hi Fishes, I have received the letter of intent from Wipro and it's mentioned - 'You will be designated as Senior Software Engineer under the WSM General Stream and will form a part of the Career Band B1 in the organization.'
Just wanted to know what 'WSM General stream' and 'Career Band B1' mean?

Very interested in t0 ico but cannot find the white paper of more info on the terms. Can anyone help?

Who else is excited for the Litecoin fork?

Hi, Currently working in TCS as testing domain.
In parallel I have learned powerbi, advance excel, basics of python, currently learning tableau as well.
I am looking for job change as well domain change(preferred location Bangalore). Could any suggest me to enter into data analyst role(if possible please refer me).
Current ctc is 3.6 in TCS with 1.7 yoe, how much I could expect to enter data analyst role based on self projects if I do.

like

I have one question please clarify
Was helping a friend in one of his assignment , Downloaded the data from my gmail and developed the report and sent to my gmail Id so in this process I just used the EY laptop will this create any problem ?

I was recently joined so wanted to get clarity on this please throw some light

like

Plunging 📉 weeeeee. #freefalling 🙌🏽

Buckle up, it’s gonna be a bumpy ride

like

I don't know if anyone can answer this. But how much do most civil engineers make? There are so many conflicting reports about "overpaid consultants" and it's almost impossible to get an actual answer

like

Please mail your CV to ammar.azizi1@gmail.com along with the Job ID from the EY careers website ( https://careers.ey.com/ ) for a referral. Please only send your CV if you have not applied directly or already asked someone else to refer already.

Please also DM me here because sometimes the CV goes into my spam folder. Cheers!

like

Anyone took personal loan from HDFC !!
What are their interest rates and charges ?
Which bank is best for personal loan considering all charges/ interest rates and all ??

How much do you typically spend on groceries each week?

like

How you guys feeling about the Bears this season?

like

AMERICAN EXPRESS India is hiring for UI Engineer role.
Title: UI Engineer – React, JSON, Cloud Engineering -21018062
Experience: 5+ years

JD screenshot is attached.
If interested, kindly DM me

Post Photo
like

I have 3.5 years of experience in DevOps.

Tech stack- Kubernetes, Docker, Jenkins, Terraform, Linux, AWS

Last working day- 14th Oct (servings NP)

It would mean a lot, if you could give me a referral.

like

Hey, what are the future scopes for DAACs. what are the general roles DAACs apply to/get after ZS?

Additional Posts in Excel Genius

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

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

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

I have some data extracted from SAP and though the size is not relatively high lets say about 45000 line items. My excel keeps crashing anything i do with it 🙄! Any clue why it is happening ?

like

Would anyone be willing to teach me vlookup?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

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

How do I compare two sheets to make sure they are identical?

like

How long did it take you to become good at excel? Like fast?

like

What would you consider "Advanced" or "Expert" level Excel usage?

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