Question about Microsoft Excel for PC

1 Answer

How to have watermark in Excel-07

Hi how to have a portion of columns to be watermarked for some category?
Tried with header option but not supporting freezed panes..Tell a solution tat will suport freezed panes too...

Posted by on

1 Answer

Agua

Posted on Jul 29, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Trying to add watermark. the watermark won't show up on certain pages if I put the watermark behind the print


Hi dear,
I was facing same problem when I tried to add watermark on PDF files but after lots of try I failed. Then I started research over internet for how to add PDF Watermark, finally I found best way to add multiple watermark on PDF files.
You must be use this tool, here is the link:
https://www.systoolsgroup.com/pdf-watermark.html

Hope You will add watermark on PDF files

Have a nice day!

Thanks

Feb 06, 2014 | A-PDF Watermark

1 Answer

Cell freeze 3 rows together at a time.


Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
For example, you may need to keep the top row of column titles visible at all times.
The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first column of cells. The selected row appears shaded.


Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the "Window" group.
A list of options appears.

Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen as you scroll down the worksheet.

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1
Freeze or lock rows and columns
also
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row or the left column.
Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.Freeze the Top Row or Left Column
1
Open the Excel spreadsheet.
2
Navigate to the "View" tab on the top menu.


3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.

4

Select the "Freeze Top Row" option to freeze the top row.

5

Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.

6

Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.

7

Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.

8

Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns
9

Open the Excel spreadsheet.

10

Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.

11

Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.

12

Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.

13

Navigate to the "View" tab on the top menu.

14

Click on "View," then click on "Freeze Panes." A drop-down menu opens.

15

Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.

16

Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.

17

Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."



http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Freeze or lock rows and columns
http://office.microsoft.com/en-us/excel-help/demo-hide-or-unhide-rows-and-columns-HA010241040.aspx
Hide or show rows and columns

Aug 14, 2013 | Microsoft Office Business & Productivity...

2 Answers

I have WP 12. When I go into WP, a pleading page appears. I found out that it was a document style called Watermark B. I can't delete it, I can't save it as something else, I can't discontinue the...



Depending on which one of the built-in pleading styles you selected. Turn on Reveal Codes (Alt + F3), and change the Watermark B to A.

Watermarks are commonly used to customize pleadings with company names and other information. The built-in pleading styles use Watermark B, so if you want to create your own watermark, use Watermark A. You can also edit your waterkarks as per your own requirements.

Apr 14, 2010 | Corel WordPerfect Office 12 Standard...

1 Answer

MS EXCEL


Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now. Ctrl 1 to open the format cells dialog. On the protection tab uncheck locked.
After you do this select the cell you want to lock. Ctrl 1 to open the format cells dialog. On the protection tab check locked.

Feb 22, 2010 | Microsoft Excel for PC

2 Answers

How do I delete a watermark. Paid for extras


I will "assume" (i know its taboo) that you have properly inserted the serial number they sent/e-mailed you after you purchased it? You might also have to register this product with them. Check to make sure that the name and serial number match EXACTLY with the one you provided to them at time of purchase. If all this fails? Contact them, they and you should have a copy of your purchase to prove that the number or reg they gave you is faulty.

Hope this helps

Sep 25, 2009 | Pinnacle Studio Plus 10 Full Version for...

2 Answers

How can i add watermarks to my videos in ulead video studio 11 plus


Hi,
Watch this video (Holiday Mini Movie Video Tutorial) on Corel site here: http://www.corel.com/servlet/Satellite/us/en/Content/1190317160694. You can add watermarks by using OVERLAY tab in Video Studio.

May 02, 2009 | Corel Ulead VideoStudio 11 Plus Full...

1 Answer

Autosuggest Possible to use in Excel


As long as your list in Excel is formatted without missing cells in column format with a header in the cell directly above your first list time. i/e if your list is in Column A and you have 500 entries, I am assuming Cell C1 is the column header, and cell C501 is the last item of your list.

An easier way to view items similar would be to go to Data/ Filter and automatic filter.

In the arrow or list format in Cell c1 - select custom, in the pop up box you can filter the contains to highlight smaller elements of your list.

May 01, 2009 | Microsoft Excel 2003 (065-03992) for PC

1 Answer

Excel formulas


{=max(if(category column = category in query, price data column))}

Nov 18, 2008 | Microsoft Excel for PC

2 Answers

Watermarks


MS Word: Page Layout tab on the Ribbon, Watermark button, in the drop-down select Custom Watermark...

Is that what you were looking for?

Aug 01, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Creating Flyers


I would suggest using a text box instead of a water mark and adjust the properties of the font color in the text box to be a very light color to your choosing then copy this and put it in the four places that you want. I think you can do this in works as well as word.

Apr 29, 2008 | Microsoft Works 7.0 for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

38 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...