Question about Microsoft Excel for PC

1 Answer

How to protract a single row in excel 2007

How to protract a single row or single colum in excel 2007

Posted by Anonymous on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 156 Answers

1. First Select entire sheet -->Right click on any cell -->Cell formatting --> Protection -->Uncheck Lock
2. Now Select the desired row -->Right click -->cell formatting -->Protection -->Check Lock cell
3. Click review tab -->Select Protect Sheet --> Give Password twice

Posted on Sep 16, 2017

Ad

4 Suggested Answers

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Anonymous

  • 28 Answers

SOURCE: EXCEl 2007

Use the "IF" function. Help should give you all the examples you will need.

If this helps you, please rate me. Thanks, Patty

Posted on Dec 30, 2007

Trimesh

  • 85 Answers

SOURCE: how to protect a single cell or row in excel

Start by selecting the entire sheet, right clicking, going to "Format Cells", "Protection" and clearing the "locked" checkbox.

Then select the rows or cells you want to protect and turn "locked" on for them.

Finally, go to Tools->Protection->Protect sheet and enable protection - setting a password might be a good idea.


Posted on Jul 04, 2009

Anonymous

  • 2 Answers

SOURCE: 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.

Posted on Apr 21, 2010

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

XLS SPREET SHEET


According to the following article, "There are over 1 million rows available in XL 2007 and 2010 - 1,048,576 to be precise - and over 16,000 columns", and "Arrow down+End takes you to row 1,048,576", and "Excel XP has 65536 rows"... http://answers.microsoft.com/en-us/office/forum/office_2010-excel/office-2010-excel-what-is-the-max-number-of-rows/82541ab3-bc70-42df-8345-af72a77ad8ce

Jun 30, 2014 | Computers & Internet

Tip

Copy PDF tables to excel?


"I have a national statistics book in PDF, it has a number of tables I want to work with in excel. So I paste all the colums and copy in Excel. However, the format is wrong, all colums in a single excel colum. How can i deal with it, any suggestion?"<br /><br />Are you also be troubled with the problem? Here share you an easy solution to solve it.<br /><br />The PDF to Excel Converter can convert PDF to Excel, convert PDF eBooks to Excel on Mac with more accurate-looking and highly-editable XLS files. There will be no need to reformat the converted Spreadsheets. PDF to Excel Converter for Mac makes it a clinch to re-use tables and spreadsheets from PDF files in Microsoft Excel.<br /><br />Get a <a href="http://www.doremisoft.com/pdf/pdf-to-excel-xls-converter-mac.html"><span style="font-weight: bold;">PDF to Excel Converter for Mac </span></a>users or <a href="http://www.doremisoft.com/pdf/pdf-to-excel-converter.html"><span style="font-weight: bold;">PDF to Excel Converter</span></a> on Windows OS<br /><br />Free download it and get a free try!<br />

on Nov 23, 2010 | Computers & Internet

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 Computers & Internet

1 Answer

What is the meaning of rows?


In Microsoft Excel, "rows" refer to data cells grouped together horizontally across a single line. The numbers on the far left of the screen refer to a row number. Similarly, the letters at the top of the workbook page refer to the columns.

Here is a picture to help:
sgoldberg08_1.jpg

In this example, there are 3 rows. All the cells in Row 1 contain the words "Row 1" and are color-coded orange. Likewise, All the cells in Row 2 are pink, and those in Row 3 are blue. Do note, however, that even though the boxes under the letter "F" aren't color-coded, they are still in the respective rows. Each color-coded line could extend for an infinite number of boxes, and each box of the same color would be part of that row.

If you find this solution helpful, please leave a positive rating!

Jun 22, 2011 | Microsoft Office Excel 2007 Full Version...

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

1 Answer

How to protect a single cell or row in excel (single cell)


Start by selecting the entire sheet, right clicking, going to "Format Cells", "Protection" and clearing the "locked" checkbox.

Then select the rows or cells you want to protect and turn "locked" on for them.

Finally, go to Tools->Protection->Protect sheet and enable protection - setting a password might be a good idea.


Jul 04, 2009 | Microsoft Excel for PC

1 Answer

How to lock cell, column or row?


Lock (Colume / Row)
  1. Select colume or row that you want to lock (by default . it is locked)
  2. Right click and select menu 'Format cell'
  3. Click tab "Protection" and then check on "Lock" option.
  4. Click ok and close this dialog.
  5. Go to ribbon 'Review' and select "Protect sheet"
  6. Typing you password
  7. Saving and close your workbook and reopen again.

Nov 19, 2008 | Microsoft Computers & Internet

1 Answer

Excel Exercise


add the correct formula to count the column and or rows

May 27, 2008 | Microsoft Windows Vista Ultimate Edition

1 Answer

Excel problem


Have you tried countif?

= countif(c:c, "Yes")

The "Yes" is CASE SENSITIVE!

You may also have to do a combo:

= count(b:b) - countif(c:c "<>'Yes'")

Wher the 'Yes' is in single quotes and the entire condition is in double quotes.

Dec 05, 2007 | Computers & Internet

1 Answer

Excel functions


Here's one way to do it. Your formulas would look like this:

B1:
=IF(OR(J1=1, J2=1, J3=1, J4=1, J5=1),1,0)

B2:
=IF(OR(J1=2, J2=2, J3=2, J4=2, J5=2),2,0)

B3:
=IF(OR(J1=3, J2=3, J3=3, J4=3, J5=3),3,0)

etc.

If you don't want the zeroes to display, format the cells with a custom number format--type: 0;-0;;@

Nov 14, 2007 | Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

158 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...