Author: admin

Printing in Excel is a bit different than printing in some other programs, such as a word processor. Printing selected objects is one of the special features in Excel.

Worksheet with Objects.

Print out with selected objects.

The steps below guide us to print only selected objects , from a number of objects (i.e. controls, images, shapes etc) in a worksheet.

Select the required check boxes.

Press Alt+f11.

A ‘Microsoft visual basic‘ window appears.

Double click on ‘This Workbook’. The cursor appears in the space at the right

viagra for sale

side, under the Workbook tab.

Now type the code below:

Private Sub Workbook_BeforePrint (Cancel As Boolean)

Dim CBX As CheckBox

For Each CBX In ActiveSheet.CheckBoxes

If CBX.Value = xlOff Then CBX.PrintObject = False

Next CBX

End Sub

After writing the macro, go to the worksheet and print the page, Now you can see the print out with selected objects only.

 

————————————————————————————————————–

Vani is a Business

cialis

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

Worksheet with object            

cialis online without prescription

Print without object

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

buy cialis online uk

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

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

Click OK.

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

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

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.

We can make Excel

sheet look like a webpage by making Excel Full Screen.

Excel sheet before full screen:

Excel Sheet after 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’.

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

Click ‘Ok’.

Picture below is a spreadsheet after hiding sheet tabs:

Removing Grid lines, Headings and Formula Bar.

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

Selecting Excel Full Screen

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

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

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

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.

To hide some calculations and to make the template look as desired with required output we need  make text invisible. We have two ways of making text invisible.

Making text font color to White .

Making text invisible using Number Format.

Suppose you have data with drop downs in column D for

Dept No, containing source from column E as below:

Text visible in column E.                                                  Text invisible in column E

Select the cells E1 to E10 which have to be made invisible. Select Font Color from Home menu.

Select White Background from Theme Colors.

Now the text in the cells E1 to E10 is invisible.

Suppose the data in

column D is linked with the data in column E as shown below:

Here we want to make column E invisible.

Select cells E2 to E8 which have to be made invisible. Select Number Format from Home Menu.

Select More Number Formats from the menu.

Select Custom and enter ’;;;’ in the Type.

Click OK.

The data in the column E is invisible.

———————————————————————————————————————————-

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.

Removing duplicates is one of the important tasks, when we work with database in excel. Many times you encounter a situation where you need to remove duplicate records/data. In the following article we tried explaining you ‘How to remove duplicates using Advanced Filter’, hope this articles helps you!

Data before removing duplicates.

Data after removing duplicates.

Let us follow step by step process for removing duplicates using Advanced Filter.

Select a cell in your data set and choose Data from menu.

Select Filter and select Advanced from Sort and Filter group.

order viagra

Advanced Filter dialogue box appears.

Enter the range of data containing duplicates in the box provided for List range.

Here the List range is ‘$B$3:$C$16’.

Check the box Unique Records Only and click OK.

Excel removes duplicates and provide

cialis buy

you a unique list of records.

————————————————————————————————————–

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.