Google Chrome. 69.0.3497.81 (64-bit) for Mac. A multi-platform web browser with open source code. Well, you can't delete anything unless you tell the program what you want to delete, and the way you do that is to select what is to be affected when you give the delete command. It isn't that difficult to do once you learn how to use the features of the program. There are quite a few techniques for easily selecting ranges of cells in the subtopic: Selecting cells, columns, or rows in Excel Help on: Two of the most efficient ways I know of, though, are to. • Use the Name Box @ the left end of the Formula Bar; • Click the content of the Name Box • Type the range to be selected [e.g., A50:K297] • Press return [ Edit> Go To ( Control+G or F5) can be used instead of the Name Box, but it's more work:-).] • If you aren't sure of the starting & ending cell references, another option is; • Click the starting cell • Scroll to reveal the ending cell • Hold Shift while you click the ending cell Then format, delete, copy, or whatever. PS: Depending on how large the range to be deleted is it might help to Filter the list on a common criteria, then select & delete the found set of records. Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J. I'm on the Insider Slow stream of Office for Mac and received the 16.9 update this morning on 2 machines. This has absolutely killed the performance of Excel on both my 2017 MacBookPro (3.1Ghz i5) and 2015 iMac (3.5Ghz i5). My old MBP (2011!) is still running Excel 15.41 and has no problems whatsoever. The issue is that when I move cell-by-cell, via cursor keys - and whether merely moving or copying and pasting - there is significant lag. This is both horizontal and vertical - and the lag is two-fold. First, when moving cell-to-cell within cells visible on the screen, this is much slower than before. More of a challenge, once the active cell is off-screen there is significant lag before the visible cells catch-up. I can be down in cell A200 (as shown by the cell-ref indicator, top-right) and the visible screen is still only on rows 130 odd. This happens even on blank/unformatted sheets, although the problem is worse when on a heavily-formatted sheet. Things I've tested: - entirely new sheets (i.e. Created in v16.9) - still the same problem - reinstalling Office: I have done this twice now on the MBP, and twice on my iMac. Daily use tips for excel. Solution to frequently faced excel problems in simple manner. You can select multiple ranges in single line code and perform the action you want to perform. I need to know how to combine two files into one macro without the range, i mean that if the data differs in both files. Tom’s Tutorials For Excel: Selecting a Large Range Without Scrolling or Dragging. Here is a handy shortcut tip when you need to select a large range. In the example, I selected a small range of B2:H5 so the pictures can fit onto this web page for demonstration purposes. But what if you need to select a large range from B2 to, say, HM62000. On the latter, at the second attempt I went for Insider Fast and so downloaded 16.10. In all cases the problem persisted. - Following advice on the MC Community forum (e.g. Checking network proxy settings). For clarity - the scrolling is fine when using the touchpad. When using that it's fast and fluid. However that work for navigating but for cell entry (e.g. Copying formulae with a cmd-cursor) it's no help. Any thoughts / ideas would be gratefully received! [As an aside, cmd-2 used to really helpfully mirror F2 and it doesn't anymore!]. ![]() ![]() Right after upgrade to 16.9 Excel is extremely slow, freezes so I cannot close page. Also When I copy a cell to paste elsewhere, the rotating (looks diff than normal) dotted line around original cell copied never goes away. I have to pick a cell out of my working area and hit Command-C to move the distracting rotating cell so it does not bug me. Also, I recall right after the, Igot a dialog box saying I needed to rebuild the MS data base. That was not the exact words and what I saw did not look like the normal wording for that task to request.I have been making a lot of changes to various very large and detailed spread sheets for days since the bug. Nch videopad tutorial. I sure hope I do not loose all that. It 'seems' to take and stay. When saving, it always tries to save to excel 2004 by default and gives a warning if I save to this (older.xls) format, I could loose some formatting or whatever. This is the ONLY reference to this issue that I have seen.
0 Comments
Leave a Reply. |