All.
I wanted to pass along something I've been working on that is proving very valuable. This trick will let you define a region in excel that will allow you to function within that region independently of all other regions you set within the sheet or workbook. It's a very nice feature when you want to set a format for a particular group of cells such as an address block etc. you can even produce pivot tables from these regions independently for analysis. You may also set the widths of these collums and heights of these rows independently of the surrounding columns or rows and you may also then set jaws to read the titles of said rows and columns independently of other regions you have within the sheet and that is the beauty. So here goes..Typically a work sheet has a default of 1 data region. In order to customize the sheet so that what you do within the data set/region you are working only effects that working area you must define each region independently. Here's how: 1. First, select the range of cells you want to set as your defined region: Put the focus on the cell in the top left of the data region then Cntrl+shift+8 selects the region automatically. Or, you can simply use the go tofeature or select the cells manually. 2. Press ALT+M M D to move to define names from the Formulas tab 3. Don't define the name of your data region using spaces. 4. Tab to "Scope" and enter the combo box to select the scope of your region..Choose workbook or sheet. Tap OK and there you have it. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20141217/11cac8c6/attachment.html> _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
