Question about Microsoft Office Excel 2003 for PC

1 Answer

I can't get Microsoft Excel 2003 to delete cells

I followed the instuctions in the help menu but the column doesn't delete. The cursor changes to a plus sign instead.

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 846 Answers

Hello,

Unless the excel spreadsheet is locked for editing then all you should have to do is Left Click on the cell you want to delete and press Backspace or the DEL key on your keyboard.

To delete multiple cells left click and hold in the middle of the first cell and drag your mouse down or across to highlight multiple cells. Then press the Backspace or DEL key on your keyboard.

Posted on Feb 12, 2012

6 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

  • 2 Answers

SOURCE: microsoft excel

Because otherwise Excel will interprate the entry as text.

Posted on Aug 31, 2007

ijay
  • 82 Answers

SOURCE: cursor in excel 2003

ceazar,be sure that completly remove the software from your HDD and again restall the software with another CD

Posted on Sep 25, 2007

  • 17 Answers

SOURCE: excel 2007 spreadsheets

The most likely problem is that you (or somebody) has R1C1 reference style turned on.

In the TOOLS menu, choose OPTIONS and switch to the GENERAL tab. Look for the checkbox labeled R1C1 reference style. If it is checked, this will cause your symptoms.

Just uncheck the box and click OK.

I'm not sure what happens to existing formulas. If you (or somebody) has written formulas that rely on the R1C1 style, I don't know if they automatically get updated to the regular style or not, but that should be easy to discover.

Posted on Jan 10, 2008

  • 20 Answers

SOURCE: CAN GET COLUMNS TO ADD UP AND GIVE TOTAL ONLY GET SUBTOTALS

Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum($A:$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.

Posted on Mar 14, 2009

thetaocat
  • 122 Answers

SOURCE: In Excel hitting tab jumps to next page

Have you tried hitting enter instead of tab. If that doesn't work, let me know and i will play with it, I have not had that problem. You may have a formula set to go to column M, that takes some work to find it, you have to go cell by cell.
You can copy the spreadsheet without formulas and redo the wholething. That takes time, but sometimes is the least stressful solution.

Posted on Apr 22, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Eliminate columns in excel worksheet


If you want to delete the column:
select column -> hit Ctrl -

If you want to hide the column:
select column -> Format -> Column -> Hide

Sep 23, 2013 | Microsoft Office Excel 2003 for PC

Tip

How to find no. of rows and columns in Worksheet.


Hello everybody, this would be my first tip on FixYa.com. Number of people might not be aware how many rows and columns are there in Microsoft Worksheet.
This is how you can find out.
1. Select A1 cell in the worksheet
2. Now press Ctrl + down arrow from your keyboard, that will take you to the bottom of the row. You can find the number on the left side.
3. Again select A1 cell in the worksheet and press Ctrl + left arrow from your keyboard, that will take you to the last column of the worksheet. Now to number, just type "=column() " , without quotations, that will give you the number of the column.
Microsoft Worksheet columns is number from A to Z, again from AA to AZ, again from BA to BZ and so on till it reached IV in Excell 2003 and earlier version.
Microsoft Excel 2003 and old version has 16,777,216 cells per worksheet (65,536 rows * 256 columns).
Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).


on Jul 27, 2010 | Microsoft Excel for PC

1 Answer

Cursor is stuck in the middle of the page and will not move to the left side. The back space button or the shift left button do not respond?


You've probably "frozen" your pane. "Freeze Panes" is a feature which allows you to keep one or more left-hand columns or top rows visible while you scroll through your worksheet.

When you ac

You didn't say which version of Excel your're using, but in Excel 2007, you can either freeze the Row 1, Column A, or any number of rows and columns based on which cell is selected (i.e., where your cursor is) when you click on "Freeze Panes."

In Excel 2007*, the way to fix this would be to click on the "View" tab, then the "Freeze Panes" icon, which will give you several choices. Click on "Unfreeze Panes." There you go.

* The steps are similar in other versions.

Aug 27, 2013 | Microsoft Excel for PC

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

3 Answers

Sir, yesterday i have brought new htc wildfire s handset i want to now in my mails i have open word, excel & pdf file format attachment please help me in this issue. Thanks & regards Prakash...


Hello PS,

Use PDF Viewer to view PDF files that you have downloaded or copied to the phone's storage card. From the Home screen, tap > PDF Viewer. On the Open file screen, tap the file you want to view.

Quick office lets you view Microsoft Office Word, Microsoft Office Excel, and Microsoft PowerPoint files on your phone. Quick office supports viewing of Microsoft Office 2003 and 2007 Word (.doc), Excel (.xls), PowerPoint (.ppt) and text (.txt) files.
Make sure you have copied the files to the phone's storage card before you open Quick office. See "Copying files to or from the storage card" in the Getting started chapter to find out how to copy files to the storage card.


From the Home screen, tap > Quick office. If you have a long file list, you can do the following to easily locate the file that you want:
Press MENU and then tap Sort to arrange files by Name or Date. Press SEARCH to enter the partial file name. Matching results will then be displayed. Tap the file you want to open.

Jul 25, 2011 | HTC Wildfire Cell Phone

1 Answer

How to freeze columns and rows on excel?


To freeze columns and rows in Excel, here's what you need to do:

- Excel 2003 & older: To do this, open your Excel spreadsheet. Select the cell that is below the left-most column heading that you wish to see. Then under the Window menu, select Freeze Panes.

- Excel 2007 & newer: Click on the View tab, and then on Freeze Panes. In here you have 3 options, first one does exactly the same thing as the one from older versions, second one freezes the top row and the last one freezes the first column.

Dec 02, 2010 | Microsoft Computers & Internet

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

1 Answer

Merge 2 columns with 550 cells each all at once?


Merging Columns In Excel Now that we've clarified what merging columns actually means, we can explore how to do it. The first step is to perform the merge for the first cells. Let's go back to our first example and suppose that we are merging column A that contains first names with column B that contains second names. We'll put the merged columns into column C. To merge cell A1 with cell B1 we woul type the following into cell C1:=A1&" "&B1


paste this into C1 (or where needed)
=A1&" "&B1

Jun 15, 2010 | Microsoft Office Excel 2007

4 Answers

Using excel to solve problem by trial and error method


In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

2 Answers

Cannot insert columns in excel spreadsheet. Comes up with error cannot shift object off sheet


This error message occurs if the following conditions are true:
  • The option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box.
  • You create an object, such as a cell comment, in any cell in a column.
  • You try to hide the column to the left of the column that contains the object, the column that contains the object, or all the columns to the right side of the column that contains the object. Or, in some cases, you try to insert a row or column in the worksheet.
There are two ways to fix this problem.
Method 1:  Temporarily toggle the option from "Nothing (hide objects)" to All In Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps:
  1. In the upper-left corner of the Excel window, click the Microsoft Office button.
  2. At the bottom of the menu, click Excel Options.
  3. Click Advanced from list of options on the left.
  4. Scroll down to the Display options for this workbook section, and then click All under For objects, show:, and then click OK.
Notes To use the keyboard shortcut to toggle this selection, press CTRL+6. 
If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2.
Method 2: Change the position property of the object to Move and size with cells To work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells. To do this, follow these steps:
  1. If the object is a cell comment, select the cell that contains the comment, right-click the cell, and then click Show Comment or Show/Hide Comments. Note This makes the comment visible.
  2. Move the pointer to the edge of the object until the pointer changes into a white arrow with four small black arrows on the pointer. Then, click the object to select it.
  3. In Excel 2003 and earlier version of Excel, click <object name> on the Format menu. Note In this menu command, <object name> is the name of the object, such as "Comment" or "AutoShape."  In Excel 2007, click Format <object name>.
  4. In the Format dialog box, click the Properties tab.
  5. Click Move and size with cells, and then click OK.
  6. If you want to hide the cell comment again, right-click the cell that contains the comment, and then click Hide Comment.
  7. Follow these steps for each object in the affected column as described in the "Cause" section. When you hide the columns, you do not receive the error message.
For more information, visit the Microsoft Knowledge Base article: http://support.microsoft.com/kb/211769

Nov 06, 2008 | Computers & Internet

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

179 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2727 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18392 Answers

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

Answer questions

Manuals & User Guides

Loading...