tag:blogger.com,1999:blog-1869924468172210809.post811425752032783211..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: Making the same change to multiple worksheetsGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger44125tag:blogger.com,1999:blog-1869924468172210809.post-12370619486974218452016-12-27T06:57:33.298+00:002016-12-27T06:57:33.298+00:00Paras
I don't see any way you could do that wi...Paras<br />I don't see any way you could do that without VBA code.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-32394141410072475072016-12-25T07:45:09.365+00:002016-12-25T07:45:09.365+00:00Greetings,
I'd like to paste the same table ...Greetings, <br /><br />I'd like to paste the same table on other sheets, but it is not in the same box? Example, for sheet one, the table starts from A1, but sheet for the table starts from B12. I need to paste the table one row after my content ends on every sheet. Thank You!Anonymoushttps://www.blogger.com/profile/10440294483912536962noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-58641781943993461342016-12-22T10:20:38.167+00:002016-12-22T10:20:38.167+00:00I'm not sure of an easy solution. I would norm...I'm not sure of an easy solution. I would normally set up a graph data sheet in between the raw data and the charts, that populates with the required year based upon lookups. This means that the chart never needs editing. You just change the year and the Graph Data tab looks up the new information, so the graphs change. I know that doesn't help you now, but could help you to avoid the problem in future spreadsheets.<br /><br />I did a quick Google and this tool might help with your immediate issue (I've not tried it though):<br /><br />http://andrewexcel.blogspot.co.uk/2011/08/aet-chart-tools.htmlGlen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-17386652406279853632016-12-22T09:35:07.089+00:002016-12-22T09:35:07.089+00:00I need some help on Excel 2003. I have an excel sh...I need some help on Excel 2003. I have an excel sheet with almost 100 chart on each worksheet, Now for the new year I have to change the scale from 2016 to 2017 for all the chart, what is the quickies way to do this. I don't want to change the date on each sheet and chart.Anonymoushttps://www.blogger.com/profile/01133689071488973055noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-44528939641034804862016-07-12T20:23:29.860+01:002016-07-12T20:23:29.860+01:00To change multiple sheets as in this post, they mu...To change multiple sheets as in this post, they must be in the same workbook.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-80137396937895730932016-07-12T18:17:17.271+01:002016-07-12T18:17:17.271+01:00I keep my login passwords in an Excel spreadsheet....I keep my login passwords in an Excel spreadsheet. I have just cleaned out 10 years' worth of these spreadsheets and have just one master sheet that I have copied in 4 different directories. Is it possible to link sheets in different directories or must they be in the same directory or workbook?<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-25390566406915599062016-07-04T11:40:20.437+01:002016-07-04T11:40:20.437+01:00The technique in the post should do what you are a...The technique in the post should do what you are after for a one-off change, but you will have to group the sheets first and then ungroup when you are done. You can group multiple sheets by clicking the first one and holding down the shift key and clicking the last one - this will select all of the sheets in between.<br /><br />If you need this to happen all the time, why not put a formula in cell A1 of all but the first sheet (Sheet1, say), being:<br /><br />=Sheet1!A1Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-58202650794511851342016-07-04T03:24:28.406+01:002016-07-04T03:24:28.406+01:00dear sir.. my question.is... (i have create someth...dear sir.. my question.is... (i have create something 230 sheet).. how to do this if i changing in first sheet .then automaticaly changes in all sheet.for example if i put any value in A1 then automatically all sheets A1 fill..the same value.... plzzz answer me soon..on.my gmail id.. princesandy786@gmail.comAnonymoushttps://www.blogger.com/profile/05249363823877518924noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-52698582474638183252016-04-02T07:06:15.740+01:002016-04-02T07:06:15.740+01:00John - I'm not sure what you are asking. As th...John - I'm not sure what you are asking. As the commenter above said, you can paste anywhere you want. Are you suggesting grouping sheets in such a way that the linking is not between specific cells in those sheets that are not in the same place? I'm pretty sure that's not possible, not without code anyway.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-80782983972344856362016-04-02T06:59:48.902+01:002016-04-02T06:59:48.902+01:00Thanks Jim, that sounds a plausible explanation.Thanks Jim, that sounds a plausible explanation.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-29948809852374261532016-04-01T23:35:13.650+01:002016-04-01T23:35:13.650+01:00you can copy stuff wherever you like, but this has...you can copy stuff wherever you like, but this has nothing to with grouping sheets - or am I missing something?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-68628851295892408932016-04-01T21:14:39.954+01:002016-04-01T21:14:39.954+01:00Hi Glen,
I might be missing it but is it possible...Hi Glen,<br /><br />I might be missing it but is it possible to have for example Sheet1 A3 copied into Sheet2 I8? Johnnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-91878736782836779972016-04-01T17:25:09.921+01:002016-04-01T17:25:09.921+01:00@Angela/Glen above (for some reason I can't us...@Angela/Glen above (for some reason I can't use the Reply against that thread)<br />Protecting doesn't seem to affect that; what it might be is that Angela has multiple sheets selected in the workbook she is copying from - when a single sheet is selected in the target, then a multi-sheet copy is copied across sheets in the target from that sheet (if sufficient exist)<br /><br />hope that makes sense<br /><br />jimAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-9795236642207723452016-04-01T14:59:32.099+01:002016-04-01T14:59:32.099+01:00Angela - could the workbook be protected?Angela - could the workbook be protected?Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-22869732159255639012016-04-01T13:11:14.005+01:002016-04-01T13:11:14.005+01:00Hi Glen,
I wonder if you can help me - my sheets ...Hi Glen,<br /><br />I wonder if you can help me - my sheets are acting as if they're grouped (ie when I paste into one sheet, it copies into them all in the same cell). However, when I right clock they do not show as grouped/there is no option to ungroup. I have never grouped them before, except to select all for the search function. Any advice would be greatly appreciated!<br /><br />Thanks,<br />AngelaAnonymoushttps://www.blogger.com/profile/08670387910909173065noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-21387287268508730392016-03-27T22:55:32.839+01:002016-03-27T22:55:32.839+01:00If it is just for ease of printing particular colu...If it is just for ease of printing particular columns and/or rows for a hard copy document it may be easier to just "hide" unwanted data. Anon E. Moushttps://www.blogger.com/profile/11737338930545999695noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-60648837231056003262016-01-14T10:41:09.355+00:002016-01-14T10:41:09.355+00:00but the question that really should be asked is:
S...but the question that really should be asked is:<br />Shouldn't this be just one table with an additional "Pay Period" column?<br /><br />jAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-66605784034799049032016-01-14T10:38:47.767+00:002016-01-14T10:38:47.767+00:00not experimented doing this with tables but…
enter...not experimented doing this with tables but…<br />enter your function on one sheet, select that cell across the other 13, reselect the first sheet and hold down ctrl<br />now press C once then PgDn, V 13 times<br /><br />not elegant, but quick and easy<br /><br />jAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-91707942118481124302016-01-13T20:58:52.739+00:002016-01-13T20:58:52.739+00:00That's okay, I didn't give you much time. ...That's okay, I didn't give you much time. I just didn't want you to waste your time researching it. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-43793438039213945392016-01-13T20:47:35.077+00:002016-01-13T20:47:35.077+00:00Sorry I didn't get back to you in time, but th...Sorry I didn't get back to you in time, but that's pretty much what I was going to say anyway!Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-37392700178826817602016-01-13T20:10:20.192+00:002016-01-13T20:10:20.192+00:00Never mind. I guess one can't perform that act...Never mind. I guess one can't perform that action with tables. I would have to go through each sheet and convert each table to a range. And if that's the case, I might as well go through each sheet and add the sum function. Booooo.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-957233013881532982016-01-13T19:49:32.267+00:002016-01-13T19:49:32.267+00:00It isn't working for me. I'm trying to sho...It isn't working for me. I'm trying to show staffing trends over multiple pay periods. So I have a sheet for each pay period. Each sheet has 14 identical tables. So all the sheets match, they just have different numbers in them. I want to add a sum function across all sheets, instead of applying the sum function to each individual sheet. But when I try to do what you suggested, this message appears: "Cannot make changes to a table or XML mapping when multiple sheets are selected." I also tried Format Painter and it didn't work either.<br /><br />Help please!<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-9275332016459025402015-09-01T03:18:47.674+01:002015-09-01T03:18:47.674+01:00And, just to look silly, I got it to work. When t...And, just to look silly, I got it to work. When the little tabs didn't turn white for me, I selected them all over again, to see if I'd messed it up. Well, you know what happened! I was actually de-selecting them! I tried it again, and it worked fine! Thank you for a great tip!!Roel and Robyn van Eckhttps://www.blogger.com/profile/13572992937798311947noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-9584717585390899982015-09-01T03:15:56.359+01:002015-09-01T03:15:56.359+01:00This comment has been removed by the author.Roel and Robyn van Eckhttps://www.blogger.com/profile/13572992937798311947noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-49661530799933436772015-09-01T03:14:30.602+01:002015-09-01T03:14:30.602+01:00I don't know who made that comment before, but...I don't know who made that comment before, but it didn't work for me, either. I wanted to begin by simply making all of my worksheets zoom out from 100% to 75%. Selected every worksheet as you instructed, then zoomed out; only the first one did it. Also, when I was holding ctrl and selecting the extra worksheets, they didn't turn white in the background, but their little tab outlines darkened. Any suggestions welcome! Thanks!Roel and Robyn van Eckhttps://www.blogger.com/profile/13572992937798311947noreply@blogger.com