How to Make Excel Look Like a Webpage?

We can make Excel

cheap cialis

sheet look like a webpage by making Excel Full Screen.

Excel sheet before full screen:

excel full screen, hide grid excel, excel hide grid, hide grid in excel, excel remove grid lines, remove gridlines excel

Excel Sheet after full screen:

remove gridlines excel, excel remove grid lines, hide grid in excel, excel hide grid, hide grid excel, excel full screen

Following are the guidelines to make Excel full screen:

Hide sheet tabs.
Remove Grid Lines, Headings and hide Formula Bar.
Select Excel ‘Full Screen’ option from ‘View’ menu.

Hide sheet tabs.

Select ‘Office’ Button and select ‘Excel Options’.

excel full screen, hide grid excel, excel hide grid, hide grid in excel, excel remove grid lines, remove gridlines excel

Select ‘Advanced’ option under ‘Display Options for This Workbook’ uncheck the box ‘Show Sheet Tabs’.

excel full screen, hide grid excel, excel hide grid, hide grid in excel, excel remove grid lines, remove gridlines excel

Click ‘Ok’.

Picture below is a spreadsheet after hiding sheet tabs:

excel full screen, hide grid excel, excel hide grid, hide grid in excel, excel remove grid lines, remove gridlines excel

Removing Grid lines, Headings and Formula Bar.

Select ‘View’ from ‘Menu’, uncheck the boxes for ‘Gridlines, Headings and Formula Bar’.

excel full screen, hide grid excel, excel hide grid, hide grid in excel, excel remove grid lines, remove gridlines excel

Selecting Excel Full Screen

Select ‘View’ from menu and Select ‘Full Screen’.

excel full screen, hide grid excel, excel hide grid, hide grid in excel, excel remove grid lines, remove gridlines excel

Picture below is a Excel spreadsheet which looks like a webpage.

excel full screen, hide grid excel, excel hide grid, hide grid in excel, excel remove grid lines, remove gridlines excel

—————————————————————————————————————

Vani is a Business Associate with p2w2, a Spreadsheet Solutions company. p2w2 has expertise in Excel Modeling, Excel Dashboards, Profitability Analysis,  Excel Invoices and Excel Bid sheets. You can contact us by email: cs [at] p2w2.com or

equifax credit score

call us at 305.600.0950.

[Bloglines] [del.icio.us] [Digg] [diigo] [Facebook] [Furl] [Google] [kirtsy] [Ma.gnolia] [MySpace] [Propeller] [Reddit] [Simpy] [Sphinn] [StumbleUpon] [Technorati] [Windows Live] [Yahoo!]


13 Comments

  • By Nanci Cieslak, October 31, 2013 @ 1:36 am

    I did the above but need to save. When I save it changes back to the ‘normal’ excel spreadsheet screen view.

    How can I save this so that this speadsheet always comes up with out tabs, heading & ruler?

  • By To Nanci Cieslak, November 10, 2013 @ 2:56 am

    Private Sub Workbook_Activate()
    Run “RemoveToolbars”
    End Sub
    Private Sub Workbook_Deactivate()
    Run “RestoreToolbars”
    End Sub
    Private Sub Workbook_Open()
    Run “RemoveToolbars”
    End Sub
    Sub RemoveToolbars()
    On Error Resume Next
    DataBaseDATA.Range(“db_RESTREMO”).Value = 0
    With Application
    .DisplayFullScreen = True
    .CommandBars(“Full Screen”).Visible = False
    .CommandBars(“MyToolbar”).Enabled = True
    .CommandBars(“MyToolbar”).Visible = True
    .CommandBars(“Worksheet Menu Bar”).Enabled = False
    .DisplayFormulaBar = False
    End With
    On Error GoTo 0
    End Sub
    Sub RestoreToolbars()
    METHOD_Get_PROGRAMFILES_PF_Path
    If FileExists(PF_Path & “\SHOWING”) Then
    DeleteFile (PF_Path & “\SHOWING”)
    Else
    On Error Resume Next
    DataBaseDATA.Range(“db_RESTREMO”).Value = 1
    With Application
    .DisplayFullScreen = False
    .CommandBars(“MyToolbar”).Enabled = False
    .CommandBars(“Worksheet Menu Bar”).Enabled = True
    End With
    On Error GoTo 0
    End If
    End Sub

  • By To Nanci Cieslak, November 10, 2013 @ 2:58 am

    woops… only use these parts:
    With Application
    .DisplayFullScreen = True
    .CommandBars(“Full Screen”).Visible = False
    .CommandBars(“MyToolbar”).Enabled = True
    .CommandBars(“MyToolbar”).Visible = True
    .CommandBars(“Worksheet Menu Bar”).Enabled = False
    .DisplayFormulaBar = False
    End With

    and

    With Application
    .DisplayFullScreen = False
    .CommandBars(“MyToolbar”).Enabled = False
    .CommandBars(“Worksheet Menu Bar”).Enabled = True
    End With

  • By Hier, May 12, 2014 @ 10:07 pm

    Asking questions are truly nice thing if you are not
    understanding anything entirely, but this article gives
    nice understanding yet.

  • By virus recovery, October 21, 2014 @ 11:28 am

    whoah this weblog is magnificent i really like studying your posts.
    Stay up the good work! You already know, many persons are looking round for this information, you
    could help them greatly.

  • By computer systems, February 11, 2015 @ 8:45 pm

    Thank you for some other informative site. Where
    else could I am getting that type of info written in such an ideal
    way? I have a project that I am simply now working on, and I have been on the look
    out for such information.

  • By http://dieghostwritingpreise.blogspot.com/, May 8, 2015 @ 2:21 pm

    Yes! Finally someone writes about academic ghostwriting.

  • By Ernie, May 28, 2015 @ 7:13 am

    My primary suggestion is to identical drop delivery in your
    ecommerce site except you might be very positive your product iss a winner with little competitors.

  • By dr oz weight loss herb, June 1, 2015 @ 9:03 pm

    Music can be an extraordinarily outstanding aid when youre exercising and several people have attested
    to this; it will keep you motivated and will surely provide a steady rhythm for you.
    This is true since you need to have so much discipline and commitment.
    The answer to getting rid of and controlling toxinjs is simple.

  • By end time prophecies fulfilled, June 9, 2015 @ 10:43 pm

    Magnificent beat ! I would like to apprentice while you amend your site, how can i subscribe for a blog site?

    The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear concept

  • By Battery, June 24, 2015 @ 12:00 pm

    To create a soft, diffuised glow, use desk lamps with opaque shades that replicate
    mild above and under.

  • By sheji, June 25, 2015 @ 11:26 pm

    How can I re-size the full screen window ? I need the appearance of ‘full screen’ but need to half of my screen.

  • By www.scoop.it, June 26, 2015 @ 3:47 pm

    A few steps and clicks that you have been using when installing, setting up, and sustaining the software.

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment