Домашняя страница Undo Do New Save Карта сайта Обратная связь Поиск по форуму
МИР MS EXCEL - Гость.xls

Вход

Регистрация

Напомнить пароль

 

= Мир MS Excel/Microsoft Excel and Dual Monitor Problem - Мир MS Excel

Регистрация · Логин: · Пароль: · · Забыли пароль?
  • Страница 1 из 1
  • 1
Модератор форума: _Boroda_, Pelena, Manyasha, SLAVICK  
Мир MS Excel » Вопросы и решения » Вопросы по Excel » Microsoft Excel and Dual Monitor Problem (Formulas / Formulas)
Microsoft Excel and Dual Monitor Problem
joejonsme Дата: Пятница, 08.06.2018, 16:19 | Сообщение № 1
Группа: Заблокированные
Ранг: Прохожий
Сообщений: 1
Репутация: 0 ±
Замечаний: 0% ±

Excel 2016
Hi,

I have an issue I didn't think of when I got another monitor for my desktop. One monitor is supposed to be used for a spreadsheet filled with information while the other screen contains the database that the information from the spreadsheet is to be entered into. The dual monitor setup is to prevent me from having to print out the spreadsheet as a working copy saving paper and ink.
However, since the spreadsheet is now on a computer screen I obviously can't place a ruler on in to keep my place. If there is nothing to direct my eye then the lines bleed together when I look at them!
Of course I can highlight the line in excel I'm looking at, but when I click away from the spreadsheet to the database the highlight is removed causing the problem once again.
Has anyone found a solution to a problem like this?

Please help.

I didn't find the right solution from the Internet.

References:-
https://arstechnica.com/civis/viewtopic.php?f=15&t=107908
Motion graphics video service

Thanks!
 
Ответить
СообщениеHi,

I have an issue I didn't think of when I got another monitor for my desktop. One monitor is supposed to be used for a spreadsheet filled with information while the other screen contains the database that the information from the spreadsheet is to be entered into. The dual monitor setup is to prevent me from having to print out the spreadsheet as a working copy saving paper and ink.
However, since the spreadsheet is now on a computer screen I obviously can't place a ruler on in to keep my place. If there is nothing to direct my eye then the lines bleed together when I look at them!
Of course I can highlight the line in excel I'm looking at, but when I click away from the spreadsheet to the database the highlight is removed causing the problem once again.
Has anyone found a solution to a problem like this?

Please help.

I didn't find the right solution from the Internet.

References:-
https://arstechnica.com/civis/viewtopic.php?f=15&t=107908
Motion graphics video service

Thanks!

Автор - joejonsme
Дата добавления - 08.06.2018 в 16:19
SLAVICK Дата: Пятница, 08.06.2018, 16:32 | Сообщение № 2
Группа: Модераторы
Ранг: Старожил
Сообщений: 2249
Репутация: 746 ±
Замечаний: 0% ±

2007,2010,2013,2016
Hi
Maybe you should use something like "coordinate selection".
Look example from this topic.
К сообщению приложен файл: 9774219.xlsm(19.9 Kb)


Иногда все проще чем кажется с первого взгляда.
 
Ответить
СообщениеHi
Maybe you should use something like "coordinate selection".
Look example from this topic.

Автор - SLAVICK
Дата добавления - 08.06.2018 в 16:32
bmv98rus Дата: Пятница, 08.06.2018, 22:31 | Сообщение № 3
Группа: Проверенные
Ранг: Старожил
Сообщений: 1261
Репутация: 214 ±
Замечаний: 0% ±

Excel 2013/2016
joejonsme, there is no dual monitor problem. You have the same issue if share one screen for several applications and activate not excel window. I think there is no solution but some times I select spreadsheet range and copy it into the сlipboard. Dashed line will be active till next copy operation. Look at the picture.


К сообщению приложен файл: 7538540.jpg(22.0 Kb)
 
Ответить
Сообщениеjoejonsme, there is no dual monitor problem. You have the same issue if share one screen for several applications and activate not excel window. I think there is no solution but some times I select spreadsheet range and copy it into the сlipboard. Dashed line will be active till next copy operation. Look at the picture.



Автор - bmv98rus
Дата добавления - 08.06.2018 в 22:31
Мир MS Excel » Вопросы и решения » Вопросы по Excel » Microsoft Excel and Dual Monitor Problem (Formulas / Formulas)
  • Страница 1 из 1
  • 1
Поиск:

Яндекс цитирования
© 2010-2018 · Дизайн: MichaelCH · Хостинг от uCoz · При использовании материалов сайта, ссылка на www.excelworld.ru обязательна!