+ Reply to Thread
Results 1 to 17 of 17

How to remove white space from spreadsheet header?

  1. #1
    Registered User
    Join Date
    07-13-2021
    Location
    Bangalore
    MS-Off Ver
    2019
    Posts
    7

    How to remove white space from spreadsheet header?

    How to remove white space from spreadsheet header?
    excelerror.png
    Last edited by KudlaKudla; 07-13-2021 at 02:11 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,072

    Re: How to remove white space from spreadsheet header?

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-13-2021
    Location
    Bangalore
    MS-Off Ver
    2019
    Posts
    7

    Re: How to remove white space from spreadsheet header?

    I think you did not get my question. Please see the attachment or screenshot.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,072

    Re: How to remove white space from spreadsheet header?

    We can NOT edit a picture of a spreadsheet!!!

    YOU did not "get it"!!
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh

  5. #5
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: How to remove white space from spreadsheet header?

    Quote Originally Posted by KudlaKudla View Post
    I think you did not get my question. Please see the attachment or screenshot.
    I'm afraid we cannot reproduce your situation. Without a sample workbook to see the behavior is quite impossible to help. A picture is not enough.
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,072

    Re: How to remove white space from spreadsheet header?

    Quote Originally Posted by KudlaKudla View Post
    I think you did not get my question. Please see the attachment or screenshot.
    Yes, I did. That's why I asked to see the actual workbook. Too late now - I have to go out.

    If you are asked to do something here, there will be a good reason for it. Don't ignore such requests in future.

  7. #7
    Registered User
    Join Date
    07-13-2021
    Location
    Bangalore
    MS-Off Ver
    2019
    Posts
    7

    Re: How to remove white space from spreadsheet header?

    Yes, you all are right. I did not understand that I need to upload a sample excel sheet. Let me upload now. Kindly help

    Sorry again for the confusion. Thanks for your support. Please help.
    Attached Files Attached Files
    Last edited by KudlaKudla; 07-13-2021 at 04:17 AM.

  8. #8
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: How to remove white space from spreadsheet header?

    Is it formula bar?

    Point the mouse into the bottom edge untill 2-D arrow appear, hold the left button then drag.
    Quang PT

  9. #9
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: How to remove white space from spreadsheet header?

    I'm afraid that is no problem with your workbook. This behavior can be generated by one of add-ins that you are using in Excel.

  10. #10
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,072

    Re: How to remove white space from spreadsheet header?

    It's not the formula bar... the pic shows that clearly enough.

    Your sample file is OK for me. So yes... it may be an add-in...

  11. #11
    Registered User
    Join Date
    07-13-2021
    Location
    Bangalore
    MS-Off Ver
    2019
    Posts
    7

    Re: How to remove white space from spreadsheet header?

    Where do I see all the add in's so that I can disable them?

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,072

    Re: How to remove white space from spreadsheet header?

    File | Options | Add-Ins ...

  13. #13
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,072

    Re: How to remove white space from spreadsheet header?

    Are you using 2 monitors on your PC?

    https://techcommunity.microsoft.com/...elp/m-p/195547

  14. #14
    Registered User
    Join Date
    07-13-2021
    Location
    Bangalore
    MS-Off Ver
    2019
    Posts
    7

    Re: How to remove white space from spreadsheet header?

    Yes, I see new plugin added. Got it

    Attachment 740395

  15. #15
    Registered User
    Join Date
    07-13-2021
    Location
    Bangalore
    MS-Off Ver
    2019
    Posts
    7

    Re: How to remove white space from spreadsheet header?

    Yes, You got it, awesome. I am using 2 monitors and a desktop extended. when I dragged the spreadsheet to the primary small monitor "white space" disappeared and plugin visible.
    So there is no solution to it ?

  16. #16
    Registered User
    Join Date
    07-13-2021
    Location
    Bangalore
    MS-Off Ver
    2019
    Posts
    7

    Re: How to remove white space from spreadsheet header?

    Issue resolved by setting the Option "Optimize for compatibility" - Thanks Glenn Kennedy

    How to mark it as answer? and how to close this thread?

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,072

    Re: How to remove white space from spreadsheet header?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove the white space between data in pie chart?
    By awefawefwe in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-18-2018, 01:47 AM
  2. Replies: 1
    Last Post: 02-22-2016, 06:01 AM
  3. Remove Space between number and letter on excel spreadsheet
    By BowHunter09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 09:06 PM
  4. [SOLVED] Remove "white space"
    By jhren in forum Excel General
    Replies: 6
    Last Post: 06-17-2013, 03:29 PM
  5. Make excel charts square, remove white space at the sides?
    By smile0 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 05-30-2012, 07:12 AM
  6. How do I remove white space around a chart?
    By Fred Zack in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2006, 01:20 PM
  7. [SOLVED] Code / Add In to remove unnecessary white space
    By Gazza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1