The Book-keepers Forum (BKF)
The Book-keepers Forum (UK) -> Book-keeping Software -> Excel - getting formulas to follow on
Post Info TOPIC: Excel - getting formulas to follow on
Rhianrach


Expert

Status: Offline
Posts: 1609
Date:
Excel - getting formulas to follow on
Permalink Closed

Ok I've set up a simple cash book that analyzes and checks everything and gives a running total etc etc, however whenever I insert extra rows the formulas don't seem to follow on.
What should happen is I put in a figure go to the analysis code column put in a code this puts the figure in the correct column and adjusts the totals accordingly, if I insert extra rows the formulas are added only if I put an analysis code in so if I miss that any lines after that dont get added up in the totals or get analysed, it just stops unless I copy down the columns and adjust the formulas for the totals, the point being that if I miss an analysis it's supposed to show in the check column and then carry on totalling the rest of the rows.

Basically I want to insert rows that allow gaps that can be filled in later if need be without halting the workings of the spreadsheet.

I could maybe explain that better. hmm

__________________
Steve
Rhianrach


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

Then I discovered the list function and everything ended up nice :)

__________________
Steve
attilabenko


Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

Hi Steve,

Congratulations! clap.gif

__________________

Attila
Rhianrach


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

However my brains have managed to ooze out of my ears. biggrin

Being a bit of a novice and not even knowing list existed it was a lucky find on google whilst searching for a macro with the same functionality.

Are you any good on excel Attila? or does it make you want to chew crayons like me? evileye


__________________
Steve
attilabenko


Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

the crayons. I learnt some bits of excel once, used it like ten years ago but nowdays only excel i do is just using given templates so any time i need something it is the case of reading all help files, google, ask workmates etc. and hoping I can get away with not learning everything again...but I suppose I will have to. :(

__________________

Attila
BackOfficeGroup


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

I have a great book called Excel formulas for 2007, although as I have just looked on my bookshelf, someone has knicked it!!

P

__________________
Rhianrach


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

I need that book, or access to google, I can never remember where to put brackets commas etc, I think it's something you have to use every day to be honest.

__________________
Steve
Julies bookkeeping


Veteran Member

Status: Offline
Posts: 72
Date:
Permalink Closed

I still cannot find most things I need in office 2007, I hate it. bring back 2000 lol

__________________
julie
semsley


Guru

Status: Offline
Posts: 1329
Date:
Permalink Closed

I still use 2000 at home, but am forced to use 2008 for Mac (which is like 2007) at work and I hate it, I can never find what I know is there somewhere, it's sooooooo frustrating and time-consuming.  Page break preview seems to have disappeared into the ether and I loved that for sorting out what I wanted where.

__________________

Advice from beyond the grave!!!

E&OE
Peasie


Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

semsley wrote:

Page break preview seems to have disappeared into the ether and I loved that for sorting out what I wanted where.

I may be misunderstanding what Page Break Preview is - but aren't the page breaks left behind when you press Ctrl - P and then cancel. Or Ctrl + F2 and then cancel.

 



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/
BackOfficeGroup


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

its all there, you just need to learn where it all is. I find 2007 so good now that I have got used to it.

Page Break is under the 'insert' tab, well it is on 2007, not sure about Mac?

P

__________________
Brewsie


Veteran Member

Status: Offline
Posts: 93
Date:
Permalink Closed

In 2007, Page Break View is on the View tab - 3rd from the right

__________________
BackOfficeGroup


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

Brewsie

Is your 2007 different to mine? Insert tab, 3rd from the left?

P

__________________
Wella


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Hi Philip

Sheila was asking about page break view. I think you are describing inserting an actual page break.

I may be wrong of course as I am still on 2000.

Has anyone tried Openoffice.org from Sun Microsystems? It seems to be an MS Office 2007 lookalike but at a fraction of the price (free)

Bill

__________________

 

 
semsley


Guru

Status: Offline
Posts: 1329
Date:
Permalink Closed

Bill you're right it was page break view I can't find in 2008 for Mac. Both me and the production manager have taught IT and neither of us could find this view and believe me we tried.

Before I got parallels for the Mac to enable me to use Sage on a virtual machine instead of having to shut down and re-start as either windows or Mac using bootcamp I used to use Openoffice wordprocessor and spreadsheet (to save having to keep swapping to do office stuff in Mac and accounts stuff in windows).

I thought it was very good, however, it does have it's quirks, I found trying to drag things around a bit of a drag (ha ha). Also when predictive texting if you wanted to choose what you had written before in a cell it then took you to the row below - maddening. Also the word processor had all the stuff but under different menus eg page setup was not under File, I think it was in either Format or Edit - haven't used it in a while 'cos now I have magic parallels.

__________________

Advice from beyond the grave!!!

E&OE
BackOfficeGroup


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

Bill

I was thinking of Word but explained about Excel! Its the heat you know, very nice but not to work in...

P

__________________
attilabenko


Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

Hi,

On Excel 2007 there is page break view but on Office 2008 for Mac there isn't.
Sheila, if they let you, you could install Excel 2004 where you can have page break view.
There is a Service Pack (SP1) out for 2008 I don't know have you got this installed or not with this one installed at least you can move the page break in normal view.
It is good to have graphic designers at work, they use Mac and they know a lot about it :)

__________________

Attila
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
The Book-keepers Forum (UK) -> Book-keeping Software -> Excel - getting formulas to follow on
Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About