MAKING FORMULA'S PERMANENT

Discuss the spreadsheet application

MAKING FORMULA'S PERMANENT

Postby FTWDBLOCK » Wed Dec 26, 2007 5:54 pm

I HAVE A SPREADSHEET IN WHICH I ENTER DATES & INVOICE NUMBERS AND OTHER INFORMATION, SALES PERSON, ETC. IN TWO COLUMNS, I HAVE THE SPREADSHEET READ THE COLUMN ABOVE IT ENTERING THE SAME DATE (UNLESS I CHANGE A CELL) AND THE INVOICES ADDING 1 NUMBER (EXAMPLE 1001, 1002, 1003, 1004 ETC). NOW THAT I HAVE COMPLETED THE SPREADSHEET, I WOULD LIKE TO MAKE THE INFORMATION IN THOSE TWO COLUMNS (THE DATE AND INVOICE) PERMANENT SO I CAN SORT THE INFORMATION TO BETTER SEE WHAT EACH SALEPERSON IS DOING. I HIGHLIGHT 15 COLUMNS X 400 LINES AND HAVE YET TO FIND THE PROPER WAY TO MAKE EACH CELL PERMANENT

ADVISE
FTWDBLOCK
 
Posts: 1
Joined: Wed Dec 26, 2007 5:31 pm

Re: MAKING FORMULA'S PERMANENT

Postby acknak » Wed Dec 26, 2007 7:03 pm

Here's the general method for converting formula cells to their results:

1) Select the cells you want to convert.
2) Edit > Copy -- copy to the clipboard
3) Edit > Paste Special -- paste them back into the same cells, with some special options:
___Uncheck: Selection / Paste all
___Check: Selection / (everything else except formulas)
___OK

That said, I have to ask "Are you sure you want to do this?" You are (potentially) throwing away information (the formulas) that you may need to refer to later on, and your "permanent" copy is really no safer than what you have now. This kind of calculation will not change unless you change something.

Some alternatives:

* Make the spreadsheet file read-only.
* Export to a PDF. That will be readable on-line, but not changeable.
* Do the copy operation above, but paste the cells to a new sheet in the same file. You'll still have the formulas to go back to.

PS: If you can, use mixed-case (upper & lower) for you messages here: all-upper-case text is much harder to read. Some even consider it offensive.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 16 guests