Как в Excel отобразить скрытые ячейки

В программе MO Excel есть функция, при использовании которой можно скрывать выбранные столбцы, строки или полностью страницы в книге. Лицензионную версию которой вы можете купить у нас со скидкой.

Для того чтобы скрывать или отображать ячейки используют одни и те же инструменты. Для доступа к данной функции используется панель инструментов или контекстное меню.


  1. Для начала необходимо выделить нужные вам столбцы, либо строки. Для этого нужно выполнить следующие действия: наведите курсор на первую из нужных вам строк (столбцов), далее нажав и не отпуская левую клавишу мыши, переведите курсор на конечную строку (столбец). Так выделятся нужные вам ячейки.
  2. Далее нужно будет открыть вспомогательное меню, нажав правой клавишей мышки по ранее выделенным вами ячейкам. В открывшемся меню нажать «Скрыть».
    Функция «Скрыть»
    Функция «Скрыть»

    Выделенные ранее ячейки будут скрыты. Для отображения ранее скрытых строк (столбцов) необходимо обозначить соседние с ними ячейки, далее также открыть вспомогательное меню и выбрать пункт «Отобразить».

    Функция «Отобразить»
    Функция «Отобразить»
  3. Если скрывать или отображать вы будете с помощью панели инструментов, тогда полностью выделять строки либо столбцы не следует, достаточно будет выделить ячейку, либо группу ячеек необходимых вам. После этого в окне программы откройте вкладку «Главная». Откройте меню, выберите пункт «формат» в блоке «ячейки».
  4. В открывшемся меню, в подгруппе «Видимость» нажмите «Скрыть или отобразить». В открывшемся вспомогательном списке команды расположенные выше полосы предназначены для скрытия ячеек. Выберите, подходящую в вашем случае, команду. Для того, чтобы скрыть целый лист никаких выделений в документе производить не нужно.
  5. Для отображения скрытых данных необходимо выделить соседние с ними видимые ячейки. Потом вызвать то же меню, что и в случае со скрытием, выбрать нужную вам команду. В случае, если вы хотите отобразить ранее скрытый лист, ничего не выделяя нажмите на строку «Отобразить лист», появится список возможных для отображения листов, в котором выберите нужный вам лист.

Приятной работы!

Видео: Как в Excel отобразить скрытые ячейки

Сергей Гришечкин

Главный редактор информационного портала BestHard.

sergey2829 имеет 750 сообщений и подсчета голосов.Посмотреть все сообщения sergey2829

36 thoughts on “Как в Excel отобразить скрытые ячейки

  • 13.05.2019 в 18:50

    Hi there it’s me, I am also visiting this web page on a regular basis,
    this site is actually pleasant and the users are actually sharing pleasant thoughts.

  • 06.09.2019 в 18:43

    Its like you read my mind! You appear to know a lot about this,
    like you wrote the book in it or something. I think that you
    could do with some pics to drive the message home a little bit,
    but other than that, this is wonderful blog. An excellent read.
    I will definitely be back.

  • 07.09.2019 в 18:51

    I read this post completely about the resemblance of hottest and earlier technologies, it’s
    amazing article.

  • 11.10.2019 в 08:40

    Howdy! I could have sworn I’ve visited this
    web site before but after going through many of the articles I realized it’s new to me.
    Anyways, I’m certainly delighted I came across it and I’ll be bookmarking it
    and checking back frequently!

  • 30.10.2019 в 22:43

    That is a really good tip especially to those new to
    the blogosphere. Simple but very precise information… Many thanks for sharing this one.
    A must read post!

  • 05.11.2019 в 11:59

    I’m really loving the theme/design of your weblog.
    Do you ever run into any web browser compatibility problems?

    A number of my blog readers have complained about my blog
    not operating correctly in Explorer but looks great in Firefox.
    Do you have any advice to help fix this problem?

  • 12.11.2019 в 05:32

    Hey there! This is kind of off topic but I need some
    advice from an established blog. Is it hard to set up your own blog?
    I’m not very techincal but I can figure things out
    pretty quick. I’m thinking about creating my own but I’m not sure where to begin.
    Do you have any ideas or suggestions? With thanks

  • 14.11.2019 в 01:27

    It’s actually a great and helpful piece of information. I’m satisfied
    that you simply shared this helpful info with us.
    Please stay us informed like this. Thank you for sharing.

  • 15.11.2019 в 05:01

    Greetings! Very useful advice in this particular post!
    It is the little changes that make the greatest changes.
    Thanks a lot for sharing!

  • 16.11.2019 в 04:54

    I feel that is one of the most significant info for me. And i’m satisfied studying
    your article. However should statement on some common issues, The web site style is ideal, the articles is truly
    great : D. Excellent job, cheers

  • 18.11.2019 в 15:06

    Good post. I learn something totally new and challenging on sites I stumbleupon every day.
    It will always be interesting to read through content from other authors
    and practice a little something from other websites.

  • 23.11.2019 в 09:36

    Thanks for your marvelous posting! I certainly enjoyed reading
    it, you will be a great author. I will make sure
    to bookmark your blog and will often come back in the foreseeable future.
    I want to encourage you continue your great posts, have
    a nice afternoon!

  • 28.11.2019 в 03:04

    I read this post completely about the resemblance of latest
    and earlier technologies, it’s amazing article.

  • 30.11.2019 в 02:39

    I’m extremely impressed with your writing skills and also
    with the layout on your blog. Is this a paid theme or did you modify it yourself?
    Either way keep up the nice quality writing, it is rare to see a nice
    blog like this one today.

  • 04.12.2019 в 00:42

    Definitely believe that that you said. Your favourite reason appeared to
    be at the internet the easiest factor to take into account of.
    I say to you, I certainly get annoyed at the same time as folks think about worries
    that they just don’t know about. You managed to hit the nail upon the highest as neatly as defined out the entire thing without having
    side effect , folks can take a signal. Will probably be again to get more.

  • 04.12.2019 в 20:30

    I simply could not leave your website prior to suggesting that I actually enjoyed
    the standard info a person supply in your
    guests? Is gonna be again steadily to inspect new posts

  • 06.12.2019 в 07:10

    Heya i am for the primary time here. I found this board and I to find It truly
    useful & it helped me out much. I’m hoping to present something again and help others like you helped me.

  • 06.12.2019 в 18:14

    I got this web site from my pal who informed me on the topic of this website and at the moment this time I am browsing this web site and reading very informative posts at this

  • 08.12.2019 в 16:48

    You’ve made some decent points there. I looked on the net to
    learn more about the issue and found most individuals will go
    along with your views on this web site.

  • 10.12.2019 в 02:50

    I loved as much as you will receive carried out right here.
    The sketch is attractive, your authored subject matter stylish.
    nonetheless, you command get bought an nervousness over that you wish be delivering the following.
    unwell unquestionably come further formerly again since exactly the same nearly very often inside case you shield this increase.

  • 11.12.2019 в 06:24

    Fantastic blog you have here but I was curious about if you knew of any
    message boards that cover the same topics talked about in this article?

    I’d really love to be a part of group where I can get opinions from other experienced
    individuals that share the same interest.
    If you have any recommendations, please let
    me know. Thank you!

  • 21.12.2019 в 12:47

    Great info. Lucky me I found your website
    by accident (stumbleupon). I have saved as a favorite for

  • 26.12.2019 в 20:57

    Hello, I believe your blog could possibly be having internet browser compatibility problems. Whenever I take a look at your website in Safari, it looks fine however, if opening in IE, it’s got some overlapping issues. I merely wanted to provide you with a quick heads up! Aside from that, great blog!

  • 31.12.2019 в 03:13

    Hey are using WordPress for your blog platform?
    I’m new to the blog world but I’m trying to get started and
    create my own. Do you require any coding expertise to make your own blog?
    Any help would be really appreciated!

  • 01.01.2020 в 12:39

    I have to thank you for the efforts you’ve put in penning this website.
    I’m hoping to see the same high-grade content by you in the
    future as well. In fact, your creative writing abilities has inspired me
    to get my own website now 😉

  • 17.01.2020 в 07:03

    Useful information. Lucky me I found your website by accident, and I’m stunned why this
    accident did not took place earlier! I bookmarked it.

  • 15.02.2020 в 10:06

    Hello there, There’s no doubt that your blog may be having web browser compatibility problems.
    Whenever I take a look at your site in Safari,
    it looks fine however, if opening in I.E., it has some overlapping issues.
    I merely wanted to provide you with a quick heads up!
    Apart from that, fantastic blog!

  • 20.02.2020 в 01:52

    In fact when someone doesn’t be aware of afterward its
    up to other people that they will help, so here it takes place.

  • Уведомление: Google

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *