How do I get to a specific place in numbers?

I am working in a Numbers spreadsheet and the columns have over 4,000 entries. If I am at number 3689 is there a way to get to the top or to number 100 without scrolling back thru the entire column?

MacBook, iOS 5

Posted on Oct 16, 2011 4:08 PM

Reply
5 replies

Oct 18, 2011 1:36 AM in response to luannfromnewcastle

You may enter my iDisk (address below)

and download :

For_iWork:iWork '09:for_Numbers09:gotoCell.zip

which would give you a script which mimic the missing Go to cell feature.


I'm testind a new storage area to replace iDisk which will die in june 2012.


May you try to use this link :


http://www.box.net/shared/h5n458kgadae3ovmmvr2


I don't know if it allow you to navigate in the linked folder.


This other one is supposed to give direct acces to the archive entitled gotoCell.zip

http://www.box.net/shared/mlrz6bzhdsdm7rjqpzjs


Of course, it would be fine to give a feedback about these links behavior because I assume that I'm not the only one here wanting a replacement to iDisk.

At this time, if we create a free account on box.net, we get 50 Gbytes free storage which seems fine.


Yvan KOENIG (VALLAURIS, France) mardi 18 octobre 2011 10:32:27

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community



Oct 19, 2011 9:07 AM in response to Jerrold Green1

Thanks Jerrold


So, here is a Table of Contents of my new Public Storage.

You will get four links.

One for the main folder and other for embedded subfolders.


On 2011/10/19, this first link give access to "for_iWork’09"


http://www.box.net/shared/h5n458kgadae3ovmmvr2



This one give access to the folder "for_iWork’09 / for_Numbers09"


http://www.box.net/shared/fvfeot5oy86fna0emyyj


4GradeBook.zip

a_library.zip

add_value_to_selected_cells.zip

around CSV.zip

auto_chart.zip

autoNumber.zip

average&stdev_CSV.zip

batch_Numbers2excel.zip

bill_with_pictures.zip

blank_no_shadow.zip

build a table with headers.zip

build_and_fill_new_table.zip

build_schedule_mail.zip

calc_&_store_Hyperlink.zip

Calendar_loc.zip

callWolframAlpha.zip

changeRange'sColor.zip

clearance.zip

clipboard2….zip

colons2semiColons.zip

colorize_min_and_max.zip

column to rows.zip

columnsBySpaces.zip

compareTables.zip

Compteur.zip

copyPasteStyle.zip

create dictionary of functions.zip

create_ical_events_from_Numbers'09.zip

createNewTableInHistory.zip

csv2numbers.zip

csv2….zip

dateTimeAndDuration.zip

display_duplicates.zip

doc1_2_doc2.zip

duplicate Sheet and Table.zip

duplicate_sheet_and_table.zip

Excel_doc_icon.zip

extractFromAddressBook.zip

extractor #2.zip

extractor.zip

fake_AW_report.zip

fake_form.zip

fill_blank_cells.zip

fillBlanks.zip

fillTODAYtable.zip

filter on column.zip

filtre en lignes.zip

fixed_width_values_to_TSV.zip

for_labels.sparseimage.zip

for_Merge.zip

formula2bottom.zip

from_folder_2_spreadsheet1.zip

fromDoc#1toDoc#2.dmg.zip

fullChoir.zip

gotoCell.zip

horaires_de_diffusion.zip

increasePrices.zip

Insert_cells.zip

insert_CSV_in_Numbers.zip

insert_Currencies_rates.zip

insert_quotes.zip

insertBeforeOrAfter.zip

insertDateTime.zip

insertFolderContents.zip

insertInPages.zip

insertPictureWithName.zip

insertRows.zip

invoiceWithDateAndnumber.zip

isItBlank.zip

JerroldGreen_GanttChart.zip

lookup_with_style.zip

makeNewNumbersDoc.zip

multiply row cells by factor.zip

newSpreadsheetWithDate.zip

NombreEnLettres.zip

normalize_phone_numbers.zip

number_fakeSections.zip

numbers2pages2numbers.sparseimage.zip

Numbers_to_AddressBook.zip

numbers_to_TSV.zip

numérote_Numbers09.zip

open&copy.zip

open_a_file.zip

open_a_mail..zip

open_a_Numbers_custom_template.zip

open_twice.zip

openFileFromNumbers.zip

Pages2PDFattachment.zip

pivot_table.zip

popup_with_nil.zip

print_table(s).zip

ref2tables.zip

remove_duplicates.zip

removeDuplicates.zip

sales.zip

save2Numbers&PDF.zip

save2Numbers’09&xls.zip

save_Chart.zip

save_with_date_time_stamp.zip

selectArange.zip

selection2print.zip

setRowColor.zip

sortGivenSelection.zip

stampedTrigger.zip

store_CreationDate.zip

strings_to_numbers.zip

substract_times.zip

test_background.zip

Transpose.zip

uncheck_checked_boxes.zip

XL_tsv16_to_Numbers.zip




This one give access to the folder "for_iWork’09 / for_Pages09"


http://www.box.net/shared/6fj0gao9u3a8r494d23o


attributes_to_style.zip

batch_Doc2pages.zip

batch_exportPages2DOC.zip

batch_exportPages2PDF.zip

batch_Pages_to_epub.zip

batch_Pages'08_2_Pages'09.zip

batch_Pages2Doc.zip

bold 3digits numbers.zip

center_title.zip

change_a_font.zip

changeCharacterColorInPages.zip

charts_from_Pages_2_text.zip

exemple ClaudeP.zip

extract_links.zip

fromRtfToPages.zip

get_set_header_footer.zip

hide4features.zip

highlight_words.zip

html2Pages.zip

incremental_numbering_and_centering.zip

insert_document_infos.zip

insert_NO_BREAK_SPACE_ZERO_WIDTH.zip

insert_two_pages_numbers_per_page.zip

list_comments.zip

listOfPictures.zip

listOfPicturesWithSizes.zip

numérote images.zip

open_a_Pages_custom_template.zip

open_Pages’s_recents_items.zip

open_twice.zip

openAndInsertFrenchDate.zip

openAndNameInvoiceWithAnumber.zip

openAndNameWithAnumber.zip

page#_to_Links.zip

Pages écrit en cercle.zip

Pages.icns.zip

Pages2doc.zip

passeEnMinuscules.zip

remove_formatting.zip

resize_mathType.zip

save2Pages&PDF.zip

save2Pages&PDF&Doc&zip.zip

save2Pages&PDF&Doc&zip47.zip

splitMergedFile.zip

swap two ranges.zip

touch_in_the_box_Templates.zip

vBar to tab.zip

Word_doc_icon.zip




This one give access to the folder "for_iWork’09 / other_iWork’09 items"


http://www.box.net/shared/xppaki015asuuzbb34i7


2011_09_20.numbers.zip

activate_all_frames_in_iWork09.zip

add_date_formats.zip

autoSave_iWork.zip

AWdraw2iWork.zip

batch_WPSS2iWork.zip

changeFont.zip

changeFontsInTemplate.zip

clean_CSV.zip

découpe_PDFs.zip

delete_iWork_fonts_cache.zip

disable_Enable_Iso_or_Trad.zip

extract_reveal_Links.zip

flatten_expand.zip

Formatting Problem.pages 2.zip

functionsNames.numbers.zip

list_fonts_used.zip

more_recents_10_6.zip

move_backups.zip

odd_behavior_repaired.numbers.zip

openFakeTemplate.zip

openGuides_iWork'09.zip

polices_des_modèles.zip

recup_preview_pdf.zip

replace_curly_quotes.zip

set_iWork_default_font.zip

superScriptsSubscripts.numbers.zip

uninstall iWork '09.zip


Yvan KOENIG (VALLAURIS, France) mercredi 19 octobre 2011 18:07:09

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community



This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I get to a specific place in numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.