teleren/devto huggingface dataset:
How to Hide or Unhide Named Range in Excel Office 365? – Kutools
Tags: hideorunhidenamedran, kutoolsexceltutorial, kutools
Published: 2020-09-17 07:30:09

---
title: How to Hide or Unhide Named Range in Excel Office 365? – Kutools
published: true
date: 2020-09-17 04:58:51 UTC
tags: HideorUnhideNamedRan,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-hide-or-unhide-named-range-in-excel-office-365-kutools/
---

## Hide or Unhide Named Range in Excel:

In this post, we are going to see how to **Hide or Unhide Named Range in Excel Office 365** using **Kutools**. You can finish this task with the help of Kutools features because it has the **Hide/Unhide Name Range** feature. Let’s see how it works. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Steps to Hide or Unhide Named Range:

Follow the below steps to hide or unhide named range in Excel using Kutools.

- On the **Kutools** tab, **select** the **Name**  **Tools** option under the **formula** option, then **choose**  **Hide/Unhide Range Name** from the drop-down list.

![Choose Hide/Unhide Range Name](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-59.png)<figcaption id="caption-attachment-14059">Choose Hide/Unhide Range Name</figcaption>

- Now, it will open the  **Hide/Unhide Range Name ** dialog box, you can be able to see all named ranges in your workbook under the **Name list** box.

![Named Range List](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_hHryNi6I1f.png)<figcaption id="caption-attachment-14078">Named Range List</figcaption>

- Then, you can uncheck the range name to hide them or check the range name to display as you wish.
- Here, we **unchecked** the two range names such as **average** and **example**.

![Hide/Unhide Range Name dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-55.png)<figcaption id="caption-attachment-14060">Hide/Unhide Range Name dialog box</figcaption>

- After clicking the Ok button, it will show only the checked range names **Alice** and **cars,** hide the remaining range names ( **average** and **example** ) **.**

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-19.png)<figcaption id="caption-attachment-14061">Result</figcaption>

## Closure:

In this post, you can understand the steps to **Hide or Unhide Named Range in Excel Office 365** using **Kutools**. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!
Be Your Own Boss...
Published: 2020-09-17 04:09:57

“When you are unemployed, weekends are seven days long.” “Dying in the line of duty is heroic, but dying while unemployed is just stupid.” “In some cases, you can tell how somebody is being treated by their own boss from the way they are treating someone to whom they are a boss.”

follow <a href=https://www.abcassignmenthelp.com/online-assignment-help> online assignment help </a> your academic writing assistance
Email Readme on Change Action
Tags: actionshackathon
Published: 2020-09-17 04:03:01

### My Workflow
The Github action is called Email Readme on Change Action, and it is currently not being used anywhere as I just created it! 

Figured this would be a good action to have as a readme is the first interaction someone has with your repo, best to make sure it is always in its best shape on each change by notifying the repo owners via email that contains the html version of your readme directly in the email. 

Check out my post here for more info {% link tryonlinux/first-github-action-and-first-post-4bng %}

### Submission Category: 
Maintainer Must-Haves


### Link to Code
{% github tryonlinux/email-readme-on-change-action%}


### Additional Resources / Info
NPM Packages used:
[showdown](https://www.npmjs.com/package/showdown) - To convert md file to html
[sendgrid](https://www.npmjs.com/package/@sendgrid/mail) - To send html md file to email

Needs a SendGrid API Key, they are free (within a daily limit)
First Github Action and First Post!
Tags: actionshackathon
Published: 2020-09-17 03:54:39

So this is my first time posting on Dev.to, been a reader and lurker... 

I really love the fact that Dev.to had the hackathon as I probably would have not tried github actions for quite sometime nor would I have built one anytime in the near future, but I learned quite a bit with this hackathon and now know how powerful and useful they are and probably will use them in my personal and business projects. 

I will say the learning curve was a bit to wrap my head around, but once I figured out how the whole steps in the .yml action file went, and how to set secrets in github it went way faster.

{% github tryonlinux/email-readme-on-change-action %}

I defiantly welcome any feedback, as this was my first try and I only spent like half a day on it.
Don't Fear the // Todo
Tags: visualstudio, productivity, dotnet, tips
Published: 2020-09-17 03:33:04

---
title: "Don't Fear the // Todo"
published: true
description: "Ever write a TODO and fear that it will be forgotten later? Use the Visual Studio Task List to keep track of work in progress."
tags: visualstudio,productivity,dotnet,tips
canonical_url: https://quill.codes/tips/dont-fear-the-todo/
cover_image: https://quill-static.sfo2.digitaloceanspaces.com/images/tips/visual_studio_task_main.png
---

## Did You Know?

### Visual Studio tracks your "// TODO" comments so you can find them later.

From within Visual Studio Go to **View** -> **Task List**. This will display the **Task List** window and show you any area of your open Solution that has existing comments that start with `// TODO`. You can filter down to your Current Project, Current Document, or Open Documents. It even will allow you to search the list.

![Visual Studio Task View showing two TODO comments](https://quill-static.sfo2.digitaloceanspaces.com/images/tips/visual_studio_task_view.PNG)

It doesn't just recognize `// TODO`, but will also recognize `// HACK`
![Visual Studio Task View showing single HACK comment](https://quill-static.sfo2.digitaloceanspaces.com/images/tips/visual_studio_task_view_hack.PNG)

### What if I Don't Use English?

You can customize the words that trigger a Task View entry in your Visual Studio options. 

1. Go to **Tools**
2. Go to **Options**
3. Expand the **Environment options**
4. Go to **Task List**
5. Enter any words you would like to highlight from your code comments.

![Visual Studio Options dialog showing the Task List menu](https://quill-static.sfo2.digitaloceanspaces.com/images/tips/visual_studio_task_list_options.PNG)

### How Should I Use It?

Properly leveraging the **Task List** window can be fantastic for your productivity. Here are a few of the ways I have personally used this window to improve my workflow.

* Leaving occasional `// TODO` comments while prototyping when the unwritten code will not change functionality. It serves as a reminder to complete the code before delivering a milestone or making a final commit.
* When writing a Web API, create the first round of CRUD endpoints using fake data and add `// TODO` to the top of every method. When all of the base endpoints are in there is now an easy checklist to complete.
* Adding `// CONSIDER` to the list of words tracked by Visual Studio and using it to keep a list of places where long-term improvements can be made to a codebase. This can be set to a lower priority so that other tracked words stand out within the list.

## Additional Links

* [Microsoft Task View Documentation](https://docs.microsoft.com/en-us/visualstudio/ide/using-the-task-list?view=vs-2019)
The Social Dilemma, a wake-up call to society
Tags: thesocialdilemma, devdocumentary, netflix, socialmedia
Published: 2020-09-17 03:19:55

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/7nwvkhz1x3f2skftf2y3.jpg)

Today, I want to encourage you to take the time and watch the latest documentary on Netflix: The Social Dilemma. If you ever wondered whether or not AI was going to take on, how social media affects the youth, or the impact of fake news and polarization in our society, this movie is for you.

#Review and Reflection

Before I quickly summarize the most important topics that the movie cover, if you want to watch my full review and take on this documentary, you can watch my video here:

{% youtube JS3np16QWD4 %}

##A wake up call

The movie is presented in an interview-like fashion, with several experts from the top of the hierarchy of some of the most important companies in the industry raising their concerns and sharing valuable insights. This gives the documentary authority over the topic and separates it from being just a fictional or over-exageration presentation of the topic, which has happened before.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/vmdsc8g4nqnb8jdnlglz.png)

####The main topics that are covered in the movie are:
* How powerful the social nets are and how much data and efficient models they have of every user.
* Their motivations and how they study, plan and develop strategies to maximize the time you spend on their products to monetize you.
* The psychological impact this all has on individuals, and particularly in teenagers and children.
* The consequences of fake news and polarization that we already see on society today.

All these topics and more are covered both from an interview base format and through the storyline of a family that is impacted in different ways from social media and its ramifications.

If you, like myself, think these are very important topics both for us as individuals and as members of society I would encourage you to take the time, watch the movie (its only 1:30 hrs) and reflect on it. After that, you can see how you feel about it and which actions you can take to minimize the negative impacts that social media has on you.

Thanks for reading and I will see you in the next article!

[![Follow Me](https://dev-to-uploads.s3.amazonaws.com/i/xy0yzyv4gqz97a64tbyr.png)](https://twitter.com/MattCodeJourney)
Change Cursor Colour in VS code 🤯
Tags: vscode, javascript, css, design
Published: 2020-09-17 02:59:45

I’ve been using VSCode for almost 2 years now and I like it so much. I’m sure that you like it too. But I decided that it was time to customize it a bit more. I will show you how to change cursor colour in VScode. 

VSCode is an electron application. So you can change the CSS and JS way you want in VSCode for that you need one extension called "[Custom CSS and JS Loader]('https://marketplace.visualstudio.com/items?itemName=be5invis.vscode-custom-css')".
<br>


![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ikya57hnjzudupvfl7bu.png)

After installing the extension follow these steps to change the colour of the cursor.
1) Add this settings into settings.json.
```json
"editor.cursorWidth": 3,
"vscode_custom_css.imports":[""],
"vscode_custom_css.policy": true,
```
2)Create one CSS file into your machine and add the following property to that CSS file.

Feel free to choose any gradient colour you want from [uiGraients](https://uigradients.com/#JShine) and paste into the '.monaco-editor .cursors-layer .cursor ' selector.

```css
.monaco-editor .cursors-layer .cursor {
  background: #12c2e9; 
  background: -webkit-linear-gradient(
    to top,
    #f64f59,
    #c471ed,
    #12c2e9
  ); 
  background: linear-gradient(
    to top,
    #f64f59,
    #c471ed,
    #12c2e9
  ); 
}

```
3)Change the file location for 'vscode_custom_css.imports' in the settings.json
```json
  "editor.cursorWidth": 3,
  "vscode_custom_css.imports": ["file:///home/pushpak1300/Documents/vscode.css"],
  "vscode_custom_css.policy": true,
```

4)Type 'CMD +SHIFT +P' to toggle command palette and type 'Reload Custom CSS and JS' to apply settings.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/imhzwm7e55vanzocpml3.png)

5)Hooray!

If all goes well, you should have the gradient cursor in vs code.

If u have any questions please let me know in comments.

![image](https://media.giphy.com/media/1MTLxzwvOnvmE/giphy.gif)

###Honourable Mentions
Don't forget to check out this course if you want more cool feature.

{% link https://dev.to/sarthaksavvy/vscode-4-5-hours-course-for-javascript-python-php-1ik4 %}

Thank You!
Interactive example of building a component with TailwindCSS
Tags: tailwindcss, webdev, css
Published: 2020-09-17 02:47:43

I'm doing an experiment on building an interactive tutorial. I created a proof of concept which shows making of a UI component with TainwindCSS. I'm looking for feedback on how to improve this further. Check it out here -> (https://zukoni.com/tutorials/sign-up)
Labfroum is switching to Medoo from PDO Connection
Tags: news, changelog, php, pressrelease
Published: 2020-09-17 02:34:13

﻿{% github labstry-opensource/labforum no-readme %}

##😽﻿ Let's become a CAT ﻿😽﻿

**Starting from Labforum 3.1, we are switching to Medoo.**

Being based on PDO for about 3 years, we are now moving on to switch to Medoo, a cross DB solution for PHP. That means the code underlying Labforum, currently only works on MySQL or mariaDB, is about to receive cross db platform support.
Starting from version 3.1, you can use Labforum on a SQL Server db, or an Oracle DB. All up to you.   
**Introducing additional paging system**
Switching to Medoo library means cross platform limit is handled. We will add pagination the program. You can expect a better paging system used in frontend.  
**What it means to you**
Since Medoo is an additional library, you custom code will still works on MySQL database installation if it involves custom database queries.
However, we suggest you to move on using Medoo to query db as it will not work for installation with other DBs.  
**Transitional Period**
Starting from 3.0.5 , we are transitioning to Medoo in our core code.
You will see two versions of connection at the same time. $connection variable is reserved for Medoo, $pdoconnection is the variable we are currently used for PDO DB connection. If you use global $connection variable, you'll receive a Medoo object. Use Medoo->pdo to get back PDO object.
However, we don't recommend using PDO as it broke the compatibility for different DBs.
How to Validate Form Data in Laravel 8
Published: 2020-09-17 02:05:23

how to validate form data in laravel. Laravel 8 form validation example. In this tutorial, i will show you how to submit form with validation in laravel 8.

And you will learn how to store form data in laravel 8. Also validate form data before store to db.


### How to Validate Form Data in Laravel 8

1. Step 1 – Install Laravel 8 Application
1. Step 2 – Configuring Database using Env File
1. Step 3 – Create Model & Migration File For Form
1. Step 4 – Create Routes
1. Step 5 – Creating Controller
1. Step 6 – Create Blade File For Form
1. Step 7 – Start Development Server
1. Step 8 – Run Laravel 8 Form Validation App On Browser

[https://laratutorials.com/laravel-8-form-validation-example-tutorial/](https://laratutorials.com/laravel-8-form-validation-example-tutorial/ "https://laratutorials.com/laravel-8-form-validation-example-tutorial/")
Laravel 8 Form Submit to Database
Published: 2020-09-17 02:00:31

Laravel 8 form example. In this tutorial, i would love to show you how to create form in laravel. And how to insert data into database using form in laravel 8.


### How to Submit Form Data into Database in Laravel 8

1. Step 1 – Install Laravel 8 Application
1. Step 2 – Configuring Database using Env File
1. Step 3 – Create Model & Migration File For Add Blog Post Form
1. Step 4 – Create Routes
1. Step 5 – Creating Controller
1. Step 6 – Create Blade File For Add Blog Post Form
1. Step 7 – Start Development Server
1. Step 8 – Run Laravel 8 Form App On Browser

[https://laratutorials.com/laravel-8-form-example-tutorial/](https://laratutorials.com/laravel-8-form-example-tutorial/ "https://laratutorials.com/laravel-8-form-example-tutorial/")
GitHub Greeter - Greet New GitHub Users
Tags: actionshackathon
Published: 2020-09-17 01:55:55

### My Workflow
This action will check if it's a users first issue to the rep and if it is, greet them. It comes prepackaged with 2 "welcome" images as well as a basic welcome message to get you started. 

### Usage

See [this file for an example](https://github.com/anishanne/greeter/blob/master/.github/workflows/github-greeter.yml)

```yaml
name: "Issue Greeter"
on: [issues]

jobs:
  issue-greeter:
    runs-on: ubuntu-latest
    steps:
      - name: "Greeter"
        uses: anishanne/greeter@V1
        with:
          repo-token: ${{ secrets.GITHUB_TOKEN }}
          message: "![](https://cdn.anishdoes.dev/githublight.png)\nHey @{user}! Welcome to the **Greeter** repo on **Github**.
```



## Welcome Images
This action comes with 2 welcome images, you can also substitute in your own image or completely remove the image feature.
- Light Theme (Available at `cdn.anishdoes.dev/githublight.png`)
![](https://cdn.anishdoes.dev/githublight.png)
- Dark Theme (Available at `cdn.anishdoes.dev/githubdark.png`)
![](https://cdn.anishdoes.dev/githubdark.png)

## Example
As you can see, users are instantly greeted when making their [first issue](https://github.com/anishanne/greeter/issues/5) but are not greeted on their [second issue](https://github.com/anishanne/greeter/issues/6).
![First Issue Greeting](https://cdn.anishdoes.dev/greeterexample.png)


### Submission Category: 
Maintainer Must-Haves


### Link To Github
{% github https://github.com/anishanne/greeter %}
Laravel 8 Installation In windows 10 Xampp Step by step
Published: 2020-09-17 01:53:49

How to install laravel 8 on windows 10. In this tutorial, i would love to share with you how to install laravel 8 on windows 10. 


### How to Install Laravel 8 on Windows 10 Xampp

Installing laravel 8 on windows 10 xampp server step by step:

1. Step 1 – Prerequisiteto Install Composer On Windows
1. Step 2 – Server Requirements For Laravel 8
1. Step 3 – Installing Laravel On Windows 10 Xampp
1. Step 4 – Start Development Server For Laravel 8

[https://laratutorials.com/installing-laravel-8-on-windows-10-xampp/](https://laratutorials.com/installing-laravel-8-on-windows-10-xampp/ "https://laratutorials.com/installing-laravel-8-on-windows-10-xampp/")
Read This Before You Sleep Tonight
Tags: webdev, productivity, career, beginners
Published: 2020-09-17 01:31:08

😱 Do you know what blows my mind?

You guys are taking action during pandemic!!!
Learning web development and
building awesome projects...



🤓 That takes courage

Believing in yourself
when the time is tough

Listen, it is hard sometimes...

But trust me the biggest thing
standing in your way
are your beliefs...




😈 Believe in yourself

Consistently rush
towards your goals

You are talented!
You just need a small nudge
and a roadmap
to become the best web programmer


💃 Just bet on yourself

You are not alone -
I know you become a successful web dev

If you are done waiting for success to come to

Go ahead and [grab it for yourself for 70% OFF](http://bit.ly/h2r-linkedin)
Coding 🤦‍♂️
Tags: javascript
Published: 2020-09-17 01:22:28

**Today I actually thought Firefox had disabled window.alert();.**

I almost never use alert() in my code.  In this instance I was using alert() as a place holder and took the opportunity to share my impeccable sense of humor. 

```
alert('Just kidding.  You can't do that right now');
```

![Hilarious Alert Message](https://dev-to-uploads.s3.amazonaws.com/i/zclde8kka7yjtwd93kz2.png)

Hilarious, right?  (don't you roll your eyes at me!)

So I tried it out in my app... nothing happened!  I check console to be greeted by:

```
Uncaught TypeError: alert is not a function
```

WTF?

I was really ready let rip at Firefox.  The world needs to know about this.  Heads were gonna roll!  I started searching to gather evidence to see when they had disabled window.alert().  Couldn't find anything.  After more time than I care to admit, I saw a Stack Overflow answer explaining how to disable window.alert() in code:

```
alert = function() {};
```

That's when it occurred to me that this was a PEBKAC error (Problem Exists Between Keyboard And Chair).  

Could it be more likely that **I** caused this problem rather than the possibility that a widely adopted browser had suddenly disabled window.alert()?

I searched my code base and found this gem:

```
alert={};
```

Yep.  That's 20+ years javascript experience right there folks.

It would make me feel better if you guys could maybe share your own facepalm moments in the comments!  Mind you, I'm gonna feel pretty stupid if the comments are empty...


I hope you've enjoyed my first DEV post.
Standups used to make sense, they don’t anymore.
Tags: productivity
Published: 2020-09-17 01:22:19

Back when daily standups were conceived they were a good solution to waterfall development problems. Instead of working on their specification in isolation, everyone would get in a room and any issues would be surfaced before they got out of hand.

Unfortunately, they don’t really work well in the world we now find ourselves in. 

**The assumption that everyone is in the same room doesn’t translate well into online experiences.**

Somebody, somewhere, is going to have a technical glitch, or forget to mute, or have a dog turn over the laptop. Unless everyone has a dedicated home office, it’s just not going to be possible to bring the same level of concentration to the meeting. 

**Once a day isn’t enough.**

From the developer side, standups only really worked when we could have all the little conversations to clear blockages outside the standup. We don’t get those hallway conversations anymore, so the standup takes way longer than it should. You can try to keep that out of the meeting, but I’ve never seen it successfully done. Developers just want to help too much.

From the business side, the same lack of little conversations means that progress isn’t being made until tomorrow, and that utterly kills productivity. You can try to fix it by having more frequent group checkins, or a chat channel that should be monitored, but then you just wind up killing productivity because people are always getting interrupted when they need to focus.

**There is a better way.**

Instead of standups, what’s needed is continuous collaboration. Status isn’t something that exists at a point in time, it’s something that everyone should be able to see whenever they want. Questions and issues need to be reflected in that status, and should cause the appropriate people to be notified, instead of taking the entire team’s time.

Continuous actionable status is one of the things we’re trying to bring to life with Uclusion, and we hope you give it a try.