Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    mac


Advertisements:






Numbers 09 :: How Can I Disable The Grid Lines When I Am Adjusting Cell Data


I have a spreadsheet that has no grid lines, just a coloured background with numbers in each cell.When I click on any cell all the grid lines appear and it's really distracting to see what's going on in the spreadsheet.How can I disable the grid lines when I'm adjusting cell data ?


View 1 Replies (Posted: Oct 16, 2010)

Sponsored Links:

Related Forum Messages for Mac:
Numbers 09 :: Remove Grid Lines When Printing?
I am trying to print a set of financial statements and do not want to see the grid lines when printing the final document. I cannot work out how to do this.

Some posts I have read say that grid lines are described as cell borders and suggest that they can be removed using the inspectors "cell borders " facility.

I have tried to do this but cannot make it happen. If I were to successfully remove the borders/grid lines then surely this would also remove the underlines I have inserted with great effort.

Information:
imac
Mac OS X (10.6.4)

Posted: Sep 15, 2010

View 1 Replies!   View Related
Numbers 09 :: Copy 5 Lines From Text File And Paste Into Cell?
I'm trying to copy name & address information from a Word document and paste it into a single cell in a Numbers document. It always pastes each line into a separate cell.

Information:
Mac Pro - 8 core and several others
Mac OS X (10.6.1)

Posted: Oct 7, 2009

View 1 Replies!   View Related
Pages 09 :: How To Hide Grid Lines Or Cut Lines In Business Card Template
I took the business card pdf I created from a pages template to Kinkos to have some cards printed. They asked if they could have a file without the layout lines, (or are they called cut lines, grid lines, boxes??? Not sure what to call them.) So I figured it would be something really easy like hide layout or the like, but after a few hours of trying to rid the document of these I simply cannot figure out how to do this.

Information:
G5 PowerMac
Mac OS X (10.5.7)
G4 Laptop

Posted: Jul 30, 2009

View 3 Replies!   View Related
Numbers 09 :: How To Create Graphs Using Duration Cell Data
Numbers in iPad creates graphs using duration data automatically.

However, I cannot do the same in Numbers '09 on my MacBook.

I select a cell range with duration data (minutes:seconds) and I select a graph type.

The graph comes out without data. I tried to select duration data but it does not allows me.

Information:
MacBook Pro
Mac OS X (10.6.4)

Posted: Aug 28, 2010

View 3 Replies!   View Related
Numbers 09 :: Change Size And Color Of Data Underline In Cell
I know I can change the color when I put a border on the bottom of a cell, but can I change the size and color of the line when I underline the data in a cell?

Information:
iMac Intel Core 2 Duo
Mac OS X (10.6.2)

Posted: Dec 20, 2010

View 4 Replies!   View Related
Numbers 09 :: Lock Cell Format - How To Change It For Data Entry
Can I stop the format I've set for specific cells being changed whilst still allowing data entry?

I have set up a spreadsheet which is used by someone else. It deals with time so in the relevant cells, I've set the format to time & date but with the date element format set to none. This shows the time exactly as I want. The user needs to enter time data in these cells so they cannot be completely locked against alteration but from time to time, the user manages to remove the cell format so it then goes back to automatic and shows the date and time

Information:
Mac Pro Quad Core : macBook Pro 2.2GHz Core 2 Duo
Mac OS X (10.6.4)

Posted: Nov 29, 2010

View 4 Replies!   View Related
Numbers 09 :: Make Table Cell Drop Down Menu From An Existing Range In Cell
Is this possible?? Checked all over the web & coming up empty. Trying to avoid re-typing in contents from previously created tables in the cell format pop-up menu.

Information:
MacBook Pro
Mac OS X (10.5.6)

Posted: Mar 11, 2009

View 11 Replies!   View Related
Numbers 09 :: Dependent Cell And Linking List Item To Populate Another Cell
I have a list in Cell A1

Lettuce
Tomato
Bread

In Cell B1 I want to associate the price with what is chosen in Cell A1 EX:

If I chose "Lettuce" I want Cell B1 to automatically chose $1.00
If I chose "tomato" I want Cell B1 to Automatically chose $1.25

Information:
Imac
Mac OS X (10.4.8)

Posted: May 5, 2009

View 2 Replies!   View Related
Numbers 09 :: Automatically Fill Cell Based On What's Typed Into Another Cell?
I want cell G to auto fill based on what's in cell C ex. if cell C has 1: I want cell G to automatically be $125 if cell C has 2: I want cell G to automatically be $100

Information:
MacBook
Mac OS X (10.5.8)
iWorks 09

Posted: May 11, 2010

View 2 Replies!   View Related
Numbers 09 :: Making A Cell Reference Another Cell From Another Workbook?
I know this is a pretty simple question but I have had no luck trying to get it to work. I am almost embarrassed to ask it!

In the past with excel I just simply opened both workbooks and selected the cell in the first and used the =SUM function and then selected the source cell in the second of the two workbooks.

Information:
MacBook Pro
Mac OS X (10.5.7)

Posted: Jul 6, 2009

View 1 Replies!   View Related
Numbers 09 :: How To Split The Contents Of One Cell Into More Than One Cell
How do I split the contents of one cell into more than one cell? For example, split the cell "123 Main Street, Springfield, CA 12345" into 4 different cells: "123 Main Street", "Springfield", "CA" and "12345"?

Information:
MacBook Pro
Mac OS X (10.5.6)

Posted: Dec 23, 2010

View 2 Replies!   View Related
Pages 09 :: Business Cards - How Can I Avoid All Of The Grid Lines
I've built a business card using pages through the template....can't figure out how to duplicate it on the rest of the page. When I group the text and images to copy it to the other spaces it either1. deletes the first one that i created when it pastes into another section on the page2. or puts horizontal and vertical lines on the page that print out messing up the business card image.

Posted: Apr 15, 2009

View 1 Replies!   View Related
OS X Tiger :: Grid Lines Can View In The Message Viewer
Is there anyway to format the message viewer so there are grid lines between the messages and columns I find it easer to read that way

Posted: Dec 20, 2010

View 1 Replies!   View Related
Applications :: MS Office 2008 Powerpoint And Grid Lines
i just bought ms office for my mac.never used ms office in mac can anyone plz tell me how to get those gridlines while making a presentation.so formatting could be easier as my org is very strict on formating.

Posted: Mar 17, 2008

View 2 Replies!   View Related
Final Cut / Motion :: Editing Credits In 3D And Grid Lines
I am editing credits in 3D, and I need to know if there is any way I can export my movie with the 3D grid lines intact? They are only in motion but I need them to be in my final product.

Posted: Nov 19, 2010

View 4 Replies!   View Related
Intel Mac :: Why To See Grid Lines When Zoom In Close In Photoshop
Using an I-Mac, Why do you see grid lines when you zoom in close in photoshop?

Info:
iMac, Mac OS X (10.7.3)

Posted: Apr 9, 2012

View 5 Replies!   View Related
Final Cut Pro :: Wmv Export With Grey Lines And Grid?
i have legal version of flip4mac and final cut pro hd 2 and i get this grey bar with grid everytime i export to wmv using compressor

Posted: Dec 20, 2009

View 1 Replies!   View Related
OS X V10.7 Lion :: How To Disable Folders Snapping To Grid On Desktop
I want to disable snap to grid of all folders, icons, jpegs, etc. on desktop. What I want is ability to move stuff around randomly.

Info:
iMac, Mac OS X (10.7.4)

Posted: May 28, 2012

View 1 Replies!   View Related
Numbers 09 :: Link One Numbers Cell To Another Numbers Document?
Just spent a couple of hours compiling a job tracker which I was hoping to be able to use as a template for multiple job... the idea being each summary cell from each Numbers job document would feed into a master summary Numbers document.. but from the posts I've seen looks like Numbers doesn't link to external files.

Has anyone found a workaround for this yet?

Information:
macbook pro
Mac OS X (10.5.5)

Posted: Oct 1, 2009

View 1 Replies!   View Related
Numbers 09 :: How To Insert The Sheet Or Table Name Into A Cell Or The Header Footer In Numbers
Converted PC and Microsoft office user to Apple and iWorks evaluation try before you buy, can any of you experience Mac users tell me if and how I can insert either the sheet or table name into a cell or the header footer in Numbers!!!.

Information:
iMac
Mac OS X (10.5.6)
306GHz 2 GB SDRAM

Posted: Apr 13, 2009

View 3 Replies!   View Related
OS X V10.7 Lion :: Excel 2011 Mac Won't Print Grid Lines For Graphs
Excel on my mac is so confusing and i have never used it before. It prints out everything but the grid lines for the graph..without the gridlines, the graph looks weird and not easy to read..The print preview shows the grid lines on the mac but when it prints out, i get a weird graph..

Info:
MacBook Pro, Mac OS X (10.7)

Posted: Feb 14, 2012

View 3 Replies!   View Related
Numbers 09 :: Making A Grid - Page Needs To Empty?
I need to make a paper with 15 horizontal lines and 3 vertical ones with a big title on top. Of course I need to see the lines when I print them as the page needs to be "empty".I've never used numbers

Posted: Apr 21, 2009

View 3 Replies!   View Related
IWeb 09 :: Draw X - Y Grid - Plotting Data Points
Is there any simple way to draw an x-y grid and plot data points on it in iWeb (or Dreamweaver)?

Information:
G5 iMac
Mac OS X (10.5.8)

Posted: Feb 25, 2010

View 6 Replies!   View Related
Numbers 09 :: Convert Preview Pdf Data To Numbers Data
Is there any way to import or convert numerical data from an apple preview document currently in pdf format so it can read into numbers?

Information:
MacBook
Mac OS X (10.6.2)

Posted: Jul 22, 2010

View 3 Replies!   View Related
Numbers 09 :: Need To Compare Two Graphs And Adjusting Axis
I have 2 graphs: 1 have an axis that goes up to 7 and another that goes up to only 4. The problem is I need to compare 2 graphs and they should both go up to 7, even though the highest information of the second graph might be 3.

Information:
MacBook
Mac OS X (10.6.3)

Posted: Apr 6, 2010

View 4 Replies!   View Related
Numbers 09 :: Numbers - How To Split A Label In A Graph Into 2 Lines Of Text
How do I split a label in a graph into 2 lines of text. Right now, in the inspector, Axis tab, Category Axis Y, the label is "Asset Value" and shows on 1 line, I want it on 2 lines but there is nothing I can do. Is there some sort of code within the label that I have to put?

Posted: Jan 21, 2011

View 4 Replies!   View Related
Numbers 09 :: Cell Format Based On The Format Of Another Cell?
I am trying to format cells in a table based on the format of another set of cells in a different table in my worksheet.

Information:
MacPro
Mac OS X (10.6)

Posted: Sep 6, 2009

View 5 Replies!   View Related
ITunes Mac :: Grid View Artist - Cannot Set Default Grid Artwork Properly
I have an issue that I have been unable to resolve with the grid view in iTunes. I have seen others with the issue on the discussion boards, although it does not look like a widespread issue.I like to view my music in grid view, under the "artists" heading, and I prefer to have certain album artwork as the default grid artwork for most of the artists. After updating to iTunes 9.2 after I got my iPhone 4, I noticed that when I attempt to set the default grid artwork it no longer sticks immediately upon selection. I noticed after fiddling around with it that if you exit iTunes and then open it back up, the artwork will be what was selected. This is not the behavior it used to have as it used to reflect the changes immediately.

Posted: Sep 2, 2010

View 1 Replies!   View Related
Numbers 09 :: Function Formula For IF (Cell A1) = "number" THEN (Cell A2) = "name"
I believe this is a very simple formula but do you think I can find it anywhere? What I am trying to do is select a number corresponding to person's name from a list and have NUMBERS auto-enter their name when their number is entered. For instance, there is a list in the spreadsheet which has names in one column and a corresponding number for each name in the next column;

John Doe 8
Tim Thompson 6
Pat Pool 2
Joe Johnson 4

When the table portion of the spreadsheet is used, I would like to type "6" in one column and automatically have "Tim Thompson" appear in the same row in the next column.

Information:
MacBook Pro
Mac OS X (10.6.5)
Also IMac, MacBook, MacBook Air, IPad, IPods

Posted: Dec 7, 2010

View 3 Replies!   View Related
Numbers 09 :: Using Sum Cell Above?
I have a cell A1 that contains a number. I need to make cell A2+A1 then A3+A1 then A4+A1 see where I am going.

So basically I need to do something like =sum((cell above)+A1)

Any one got any ideas. Most evey thing I can find relates to excel and using VB.

Information:
MacBook Pro 15"
Mac OS X (10.6)

Posted: Oct 10, 2009

View 2 Replies!   View Related
Numbers 09 :: How To Get Zero Cell To Appear As A Duration
I have cells that calculate a duration with some cells showing something like "9h 52m" and some showing "0" when there is no duration. I get an error when I try to sum these cells that says all values need to be numbers or durations. How can I get my "0" cells to appear as durations?

Information:
MacBook Pro
Mac OS X (10.5.8)

Posted: Sep 10, 2010

View 5 Replies!   View Related
Numbers 09 :: How To Enter The Same Cell Twice In A Formula
we have a lot of complicated formulas that are long chains. In these formulas I need to reference the same cell many times , the problem is when I click on the cell again all it does is rehighlight that cell earlier in the equation. When I do this in excell it works fine. If i type the cell in it works but this can be a hassle. I like working in Iwork because the charts and graphs are nicer but I seem to be finding that some items like this, goal seek, and the fact that you can not extend a polynomiel function forward and back excell is much better than Iwork.

Information:
imac
Mac OS X (10.4.10)

Posted: Mar 13, 2009

View 1 Replies!   View Related
Numbers 09 :: Embed An Iframe In A Cell?
I realize this is a long shot, but is it possible to embed an iframe in a Numbers document? I'm assembling datasheets on websites to potentially advertise on, and analytics companies [URL] provide embeddable iframes so you can have charts on your own dashboard stay up to date with the latest stats.

Any chance there's an advanced option I'm overlooking to make that work in Numbers?

Information:
Mac Pro
Mac OS X (10.5.6)

Posted: Mar 20, 2009

View 1 Replies!   View Related
Numbers 09 :: Shortcut To Add 1 To A Cell?
I've got an inventory spreadsheet where I frequently need to add or subtract 1 unit from the cells in the "# of units" column.

Is there a way to create a script / shortcut that would allow me to add or subtract 1 unit to the current value in the cell with a click or keystroke, rather than having to manually change (for example) a 4 to a 5 if I want to add one unit into the inventory?

Information:
Macbook
Mac OS X (10.5.6)

Posted: May 11, 2009

View 16 Replies!   View Related
Numbers 09 :: Linking Cell To Another In Different Workbook
Does anybody know how to link a cell to another cell inside a different numbers document? E.g.: I have my daily sales report for each day of the week and I have my Weekly sales report. I need to add the total sales from my Monday Sales Report + my Tuesday Sales Report + etc. and put this total inside my Weekly Sales Report.

Information:
iMac 24" latest
Mac OS X (10.5.6)

Posted: May 7, 2009

View 3 Replies!   View Related
Numbers 09 :: Text Orientation In A Cell?
Is it possible to orientate a text (90, 180...) in a cell ?

Posted: Jun 15, 2009

View 1 Replies!   View Related
Numbers 09 :: Can Reference The Same Cell Twice In A Formula
Can I reference the same cell twice in a formula? i.e.. cell-(cell*25%). I was able to do this in Excel but cant seem to find a way in numbers.

Information:
macbook pro
Mac OS X (10.5.7)

Posted: Jun 23, 2009

View 2 Replies!   View Related
Numbers 09 :: Multiple If Functions In One Cell?
I suspect this is possible, I just have no idea what the syntax would be. Is it possible for 1 cell to support multiple IF functions? And how do I go about writing them?

Information:
MBP
Mac OS X (10.5.7)

Posted: Jun 27, 2009

View 4 Replies!   View Related
Numbers 09 :: Different Color Text In One Cell
How do I set a color for a group of words within a cell leaving the rest of the words black? I can make all the text within a cell the same color but when I select the words I want to be a different color the color selector in the toolbar goes away and only fx, Cancel and Accept buttons are available.

Information:
iMac 20 inch
Mac OS X (10.5)

Posted: Jul 16, 2009

View 2 Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved