GreyMamba

Thinking Allowed … (under construction)

Thinking Allowed … (under construction)

A computer once beat me at chess, but it was no match for me at kick boxing.
Emo Philips
Snippets covering IT techniques, Python coding and Rapidweaver
Just a section to cover anything related to 'Information Technology'. Computers, Coding, Algorithms, A.I. and so on. There will probably be quite a bit on how to make a web site (one of the reasons I'm actually doing this is to learn how) including much on Rapidweaver and Stacks. There will be code - most likely Python along with general computery items.

I'm quite into Python programming and as such I've written a bit of an interactive Python booklet (link opens in new window) covering some of the stuff needed to program in it.

It's probably appropriate to mention here that I've used RapidWeaver 8 to help me generate this website. I've also made use of the excellent Free DNS service to overcome the limitations imposed by not having a static IP address.

Excel - move a block without formula changes

Filed in: Spreadsheet |Excel Excel, copy cell, formula

Had a spreadsheet with a reasonably complex block of cells that I wanted to 'move' to another part of the sheet but without auto-changing the formula in it. Didn't want to go through all the formula adding '$'s everywhere, but there didn't seem to be a 'paste special' to cover this. However it can, pretty simply be done!

  1. Select the area you want to move.

  2. Use "Formulas > Show Formulas "

  3. Copy the block

  4. Paste it to a text editor (I like Notepad++ when on Windows)

  5. Copy from Notepad

  6. Paste it back into a new position in the Spreadsheet.

  7. de-select Formulas>Show Formulas

Ta-Da!

Back

Tags: copy

< Previous Post  

Nice photo from an unusual perspective. Kudos to Joshua Sortino

RapidWeaver Icon

Made in RapidWeaver