Column and Row reference

How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top and right hand side references
0
dave871 (680)
7/19/2004 10:53:02 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
1015 Views

Similar Articles

[PageSpeed] 1

Dave

Tools>Options>View.

Uncheck "row and column headers".

Good idea to spend a few minutes browsing through the various Tools>Options
tabs to see what else is available to toggle on/off.

Gord Dibben Excel MVP

On Mon, 19 Jul 2004 15:53:02 -0700, "Dave" <Dave@discussions.microsoft.com>
wrote:

>How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top and right hand side references

0
Gord
7/19/2004 11:04:21 PM
Reply:

Similar Artilces:

show columns on other worksheet without using formulas
Hi, I have 1 worksheet containing lot's records. Just like in access, each line is 1 record, and each column contains data. ex: WORKSHEET 1: name title address city 1 dfjw kjhk kjhkj kjhk 2 lmkj lkjlk lkjkuf guyg 3 drdtg xcx yjutuy hgyy Now I want to have a selection of columns on worksheet 2: ex, only name and title: WORKSHEET 2: name title 1 dfjw kjhk 2 lmkj lkjlk 3 drdtg xcx I will only add/modify rows in worksheet 1. And I want that this is filled automaticaly in worksheet...

Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that have subtotals associated with them (automatically generated via the pivot table). I need to to take the subtotals for 2009 and 2010 and calculate the % difference. Here's a screenshot of what I'm talking about: http://home.comcast.net/~wilsoch/PercentDiff.jpg Is this even possible or am I going to have to do this manually? Hi I have'nt seen the screenshot as am at work , go to Pivot Table>Formulas>Calculated Field wilsoch@comcast.net wrote: >This is what I need to do: I have rows of ...

Subtract several rows from a total
This is a multi-part message in MIME format. ------=_NextPart_000_0029_01C53AC8.AD6EB0F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Guys, I have a total in cell C32. I want to subtract numbers in cells C 34-40 = and have the answer in cell C41. I know that =3DC32-C34 will give me an = answer but I want several rows to be subtracted. What would my formula = be? I have used the insert function feature before but I don't see diff or = anything that looks like a subtraction function in there. =20 Thanks, Linda ------=_NextPa...

Deleting rows containing common data
I have an Excel 2000 spreadsheet with 30,000 rows. The rows look like this: 007-007 68-4611 68-4682 total 007-007 total 007-007 28-4831 68-2454 68-4682 total 007-007 28-4831 68-2454 68-4682 total 007-007 28-4831 68-2454 68-4682 total 007-007 68-4682 total 007-007 68-4682 total How do I delete the rows containing "total" One way: 1. Select the range and apply an AutoFilter (Data > Filter > AutoFilter) 2. On the drop-down list, select "Total". 3. Select the range again if needed. 5. Press F5 > Special and click "Visible Cells Only." 6. Remove...

Excel 2007
When you set reverse categories for the horizontal axis, I noticed that the legend (which I normally placed at the bottom of the chart), did not correspondingly reverse. Is this WAD (working as designed) ? If not, how can i overcome this as the reader would have to mentally "remap" the legend to the bar chart. Thanks very much. Hi, Reversing the Axis categories will not effect the legend order. To do that you need to change the Series Order. In 2007 this is none via the Select Data Source dialog. Chart Tools > Design > Data > Select Data. Use the Up/Down arrows in the...

how do i split a column
i have a worksheet with three columns but want to split column C in to two from row 37 down while keeping only three columns from rows 1-36. How can i do this? You can't. You could merge C1 & D1, C2 & d2 etc. but it seems a bit of overkill. What is the reason for this, there may be another solution? -- HTH RP "craig.d" <craig.d@discussions.microsoft.com> wrote in message news:973F49DB-EF87-4F64-AA13-7AEB3563757A@microsoft.com... > i have a worksheet with three columns but want to split column C in to two > from row 37 down while keeping only three col...

characters in 1 col, 1 per row
Hi all, I want to transform the text of a worddocument to Excel in a special way. In my case text is just a number of words in a number of lines (nothing special about headers, footers etc.), so something comparable with this post. I want in Excel the first charachter of the text in A1, the second in A2 and so on. This email document would result in: H i a l l , I w a n t etc. I can't figure out how to do this, your help wil be appreciated. Jack Sons The Netherlands ...

Automatic Insert Rows VBA
A Very Good Evening All, I have a macro that runs: advanced filter/copy to another place/unique, between two worksheets (Column A in each worksheet being the identfier; worksheet1 is source data,with duplicates of identifiers; worksheet2 is formula driven from the sum of the unique identifiers in Worksheet1) However...I would like the macro to automatically extend the rows in worksheet2, to accommodate the ever increasing rows of worksheet1 Here is my specific code worksheet1 = "Invoice Record" worksheet2 = "General Report" Sub CommandButton1_Click() ' A...

Chart
Hello, I created a line column chart on 2 axis. I have four data sets. The first 3 should go on the primary Y axis as columns and the 4th should go on the secondary Y axis as a line. However, Excel wants to automatically put both the 3rd and 4th data sets on the secondary axis as lines. I cannot find any command to change the 3rd data set to go onto the primary axis as a column. Any suggestions would be most appreciated! -Patty On Tue, 11 Nov 2003 13:27:33 -0800, Patty = <anonymous@discussions.microsoft.com> wrote: > Hello, > > I created a line column chart on 2 ...

Some macro help
Lets say I have selected the arbitray range of j31:ax44. I want to run some macro code that will hide every column in that selection where the entire selected column range has nothing in it (blank). Data validation may be assigned to the cells, but if nothing has been selected from the drop down list, then those cells are technically blank. There may be data entered elsewhere in the column, but it is outside of the selected range and thus shouldn't be considered for being hidden or not. Can anyone help me with some code to perform this action? TIA, AlanN How about: Option Explicit Sub...

Column names are 1,2,3,....
I just noticed today that the column names in my excel spreadsheets are no longer alphabetical, but are numerical. The column marked "1" is defined by excel as column "1C", and row "1" is defined as row "1R". How can I get the column names to change back to the alphabet? Thanks Hi! G! Use: Tools > Options > General Remove check from "R1C1 reference style" -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good...

conditional formatting: separating rows with differing values
Hi, Need help with conditional fomatting. What I need: I got a worksheet with 950 rows and 5 columns. The first row contain the headers. Columns A, B, D and E contains unique values. But the column C contains text values which repeats sequentially for 6-7 rows and changes thereafter. Now I want to put up a line (using border) through the whole row dividing this transition row. My Idea: Compare C2 with C3, if equal do nothing. Then compare C3 with C4 and so on till 2 consequtive values differ. Now divide the 2 rows using the border formatting option in conditional formatting dialog box. So...

Splitting multiple cell contents from 1st column into 4 columns
n my first column I have 4 cells (1-4) (5-8) etc. with general content. The content from each of these 4 cells needs to be placed in a separate column to make a list that I can sort etc. Example: COLUMN A 1 01-04-425-001 2 Heatherridge Road #301 3 Harry Smith 4 H25 Condo Fairfax Place 5 01-05-356-041 6 McGrath Street # 56 7 Mary Jones 8 B45 Condo Lemon Circle . . . . . . and so on and so on every 4 cells. I have hundreds of 4 cell descriptions. I just can't do this one by one. Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though I use it for e...

Activate email column to hyperlinks
I have a colume of email addresses in an excel 2002 document. I need to make them active hyperlinks - How ? Microsoft instuctinos are useless here. can't they be converted in one batch to active hyperlinks so when the email address is clicked on, the email program opens in a fresh email ? Many thanks for any help http://www.mvps.org/dmcritchie/excel/buildtoc.htm#MakeHyperlinks -- Regards, Peo Sjoblom "DixieWins" <DixieWins@discussions.microsoft.com> wrote in message news:7F59C7F2-63DE-410B-B6FF-0EA29ECC8A35@microsoft.com... > I have a colume of email addr...

Invalid column name 'ASSN_ENTSUMPROJID'
I have Project Server 2003 with SP3, SQL2005 database When i am saving a project to the Project Server, i am getting the following message: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ASSN_ENTSUMPROJID' This is happning to just one project. Please help me understand the reason behind this and if you have a solution to fix this issue. Thanks VM Find the stored procedure executing that SQL command, name of the stored procedure is in the same line of the log (ULS). Go to the procedure and re-compile it, ensure there are no red-underlined lines. ...

make dropdown list greater than 8 rows
Hello How can I make my dropdown list 12 rows instead of only 8? thanks for any help For a Forms Combo Box right click and choose Format Control-Control tab For an ActiveX ComboBox right click and choose Properties and adjust ListRows. -- Regards Dave Hawley www.ozgrid.com "SteveZmyname" <SteveZmyname@discussions.microsoft.com> wrote in message news:105058EA-1275-417C-B4BC-4023DFDAC16C@microsoft.com... > Hello > How can I make my dropdown list 12 rows instead of only 8? > thanks for any help I can change the drop down lines to 12 in the F...

Checkbox column in a table
Hi Everyone, I am a newbie in MS Access. I want to write a query for altering a table such that the new column added should be of type checkbox (which can be done by the design by going to Lookup tab in the design form). So when I open up the table that particular column should be like all filled with checkboxes. (By Default it will be Textboxes). And also how to give a default value to the checkbox ? Please help me out... ! On Tue, 25 Sep 2007 12:52:20 -0700, Cormalado <Cormalado@discussions.microsoft.com> wrote: >Hi Everyone, > >I am a newbie in MS Access. I want to w...

Delete color row
Hi, After I compare two worksheets (VB as below) and highlight the same value with colour, now I want to delete the same value row. The comparison VB that I have worked: Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=COUNTIF(New,H5)=1" Selection.FormatConditions(1).Interior.ColorIndex = 6 How do I write VB to delete color row? Raymond ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ You can't programmatically check for a color produc...

Inserting Columns
I am trying to insert a column on a worksheet and keep getting the message: : "to prevent possible loss of data Microsoft Excel cannot shift nonblank cells off the worksheet". I am using Excel 2000. I have no protection set and no merged cells anywhere on the worksheet. It does no matter where I shift the cell pointer and try to do the insert, I get the above message. I have used Excel for many years and have never seen this problem before. I'm sure there must be something obviouis I am missing, but have no idea what it could be. Please help Thanks Thanks You ...

Adjusting column widths to fit text plus extra space
I can get Excel to adjust one or more columns to fit the data by selecting the columns and double-clicking on one of the column header borders. The result is the smallest possible width for the existing data. This is a little too tight for optimum viewing. Is there a way to tell excel to choose a width that is slightly wider? In Word, there is a *Cell Margin* setting for tables. Is there anything similar in Excel? Column Auto-width has no cell margins parameters that can be set. Gord Dibben MS Excel MVP On Tue, 14 Jun 2011 06:50:36 -0700, Jennifer Murphy <JenMurphy@geospace.org>...

Rows and Columns #2
Hello, I have excel 2002. If I have say 100 words in the first row one in ecah column and now I want to copy the same words to have them going down the worksheet is there an easier way then copy and paste 100 times? Thanks, Bec Bec If I understand, copy all the words in the row, select a cell below the row, say A2 and select Edit>Paste special>Transpose (Checked) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "beccas1963" <beccas1963@discussions.microsoft.com> wrote in message news:C08F...

Column size keeps changing
Using OL2003 In a custom view I have many columns with carefully chosen sizes for each. This remained unchanged as long as I didn't resize them in OL2002. With the new 2003 version, when I click on Help for instance it opens up a sidebar to the right of the screen with the search fields and results and squeezes the view into the left hand pane.. When I close Help, my custom view is "restored" but the columns are all changed. Help! ...

Can I format an entire row based on the value of a single cell?
I would like to use the conditional formatting feature to format an entire row rather than just a single cell. For example: If the cell value = "Total" then the entire row is bold. select your range (multiple rows???). Then with A3 (say) the activecell in that selection: format|Conditional formatting formula is: =$a3="total" apply a nice format LTShelley wrote: > > I would like to use the conditional formatting feature to format an entire > row rather than just a single cell. For example: If the cell value = "Total" > then the entire row is bo...

Row Heights Incorrect Sizes
Hi, can someone please help, I've been inputting values for row heights by selecting 'Format>>Rows>>Height' and entering my required measurement of 6.5mm, but when I select 'Format>>Rows>>Height' for a second time to check if they're properly sized, instead of the 6.5mm I input I'm getting 6.35mm. This happens with columns too, they don't retain the originally required number either. I've looked in Excel's preferences and don't see anything that would make this happen either. This happens exactly the same on two different ma...

Reference based on matching values in another column?
Aloha, I'm not sure it is possible to do what I am trying to do in Excel, but I figured I'd ask anyway. I'm working on a stat spreadsheet and would like to reference cells from another sheet based on the value of a column. One column on each sheet contains names. The names on the two sheets may not be in the same order. Is there a way to reference a value on the second sheet by matching the name in the row of the two sheets and using an offset? For example if I'm in cell G10 and the name in cell B10 is Steve, is there a way for me to put a reference in G10 that goes t...