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!]


4 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.

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment