Posted on

How to Make Validation Case Sensitive?

Chaitanya is CEO of 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 call us at 305.600.0950.

Posted on

How to Take Print Without Objects?

Worksheet with object            

Print without object

print excel, printing in excel, excel print, excel printing, printing from excel, print excel sheetprint excel, printing in excel, excel print, excel printing, printing from excel, print excel sheet

Follow the steps below if you do not want to print objects in a worksheet.

Suppose you have some data and a button in your worksheet and you want

only the data to be printed without the button.

Right click on the button which you do not want to print and select ‘Format Control’.

print excel, printing in excel, excel print, excel printing, printing from excel, print excel sheet

Select Properties in ‘ Format Control’ . Uncheck ‘ Print Object’ .

print excel, printing in excel, excel print, excel printing, printing from excel, print excel sheet

Click OK.

When you select the ‘print preview’, Now you can see the print out without the object.

print excel, printing in excel, excel print, excel printing, printing from excel, print excel sheet

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

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 call us at 305.600.0950.

Posted on

How to Make Excel Look Like a Webpage?

We can make Excel

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

call us at 305.600.0950.