Загрузка страницы
Все видеоНовые видеоПопулярные видеоКатегории видео

How to Name a Large Range of Non-contiguous Cells in Excel

Named Ranges in Excel can contain non-contiguous cells - this is great for selecting cells on a form. The problem is - you can not have more than 255 characters in the "Refers to" portion of the Name Manager. How to get around this?

Thanks to a great tip from Microsoft MVP, Bob Umlas - use the Immediate Pane in the Visual Basic Environment (VBE) to solve this. Watch this video to see how it is done!

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to see all of the resources and tips that I offer.

Danny Rocks
The Company Rocks

Видео How to Name a Large Range of Non-contiguous Cells in Excel канала Danny Rocks
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
1 декабря 2010 г. 1:08:50
00:04:50
Danny Rocks
Теги
Правообладателям
Жалоба
Комментарии
Другие видео канала
Speed up Data Entry on Excel Forms By Using Named RangesSpeed up Data Entry on Excel Forms By Using Named RangesUsing a Pivot Chart to Present a Frequency Distribution ReportUsing a Pivot Chart to Present a Frequency Distribution ReportHow to Distinquish Cell Content from Cell Formatting in ExcelHow to Distinquish Cell Content from Cell Formatting in ExcelExcel's text functions help you to combine text stringsExcel's text functions help you to combine text stringsPresenting Information from a Frequency Report in an Excel Pivot TablePresenting Information from a Frequency Report in an Excel Pivot TableUse the Countif () Function to find out how many name tags have been claimed / not claimedUse the Countif () Function to find out how many name tags have been claimed / not claimedNavigate Your Excel Workbook Using Hyperlinks and Named RangesNavigate Your Excel Workbook Using Hyperlinks and Named RangesHow to Save $100.00 Each Month Refreshing Pivot Tables in Excel 2007How to Save $100.00 Each Month Refreshing Pivot Tables in Excel 2007How to Use Keyboard Shortcuts to Perform Basic File Operations in ExcelHow to Use Keyboard Shortcuts to Perform Basic File Operations in ExcelTurn your Excel spreadsheet on its side!Turn your Excel spreadsheet on its side!How to Download My Free Recording of Excel Keyboard ShortcutsHow to Download My Free Recording of Excel Keyboard ShortcutsHow to Share Excel Data with Word DocumentsHow to Share Excel Data with Word DocumentsMake your Excel Subtotals stand outMake your Excel Subtotals stand outHow to Create Hyperlinks in ExcelHow to Create Hyperlinks in ExcelGet Formula Reults Without Writing Excel FormulasGet Formula Reults Without Writing Excel FormulasHow to Return Either an Approximate or Exact Match with VLOOKUP in ExcelHow to Return Either an Approximate or Exact Match with VLOOKUP in ExcelCreate an Excel Chart with One Keystroke!Create an Excel Chart with One Keystroke!Using Paragraph Styles in Word to Improve ReadabilityUsing Paragraph Styles in Word to Improve ReadabilityHow to Use Data Validation When Creating a BudgetHow to Use Data Validation When Creating a BudgetUse the SumIf and SumIfs Functions in Excel to Analyze Accounts Receivable Status ReportUse the SumIf and SumIfs Functions in Excel to Analyze Accounts Receivable Status Report
Статистика портала
Яндекс.Метрика
© 2008-2024 «Информационно-развлекательный портал города Верхняя Салда»
| Карта портала | Реклама | Контакты | Сообщить об ошибке | Соглашения
salda.ws@mail.ru
Сейчас на сайте: 512 Статистика портала