のぶかつの部活動 since 1970
Do you know the answer to this riddle?
落ち着いて休ましてくれ・・・いろんなことに興味ありすぎて困る
ipodに好きな音楽入れる時間なし、スレイヤーのコンサートチケットもとらなあかんし、ソウルコレクターも読まないとあかんし、

ゲーム関係もやらなあかんし、勉強もせなあかんし、









 のぶかつDETH.

cellより


[なんぼ試しても、入力できひんわ」

















セル




前任者が作ったエクセルの資料の中の

あるセル内の情報を書き換えようとすると

「入力した値は正しくありません。

ユーザーの設定によって、セルに入力できる値が制限されています」

とエラーが出てしまうねん。

(ドロップダウンリストから選択することしかできないようになってんねん)

ふつうのセル同様、"入力できる値"の制限を解除する方法はありまっか?














DBのセル



入力規則が設定されています。


セルを選択して


データ→入力規則
左下に全てクリアと書かれたボタンがあるのでクリック

OKをクリック

これで解除されます。






















The20Cell20dali[1]




「ありがとう~、助かりました」










それにしても、EXCELってごういすぅやな

誰が発明しよったんや

でもなんで入力規制なんかかけるねん

シートの保護やら

いちいちパスワードを入力せなあかんかったり、便利やけども

諸刃の剣の一面もありでんな

もうちょい勉強せんならんわ

やる限りはマスターを目指したいもんでんな















せるせる





関連記事
スポンサーサイト
別窓 | 仕事部門 | コメント:25 | トラックバック:0 |
<<また、振り込むとこでしたわwww | のぶかつの部活動 since 1970 | わくわく、お疲れ様でした。>>
この記事のコメント
What's up mates, how is all, and what you want to say on the topic of this piece of writing, in my view its really amazing for me.|
2016-07-10 Sun 09:55 | URL | women leotards #EBUSheBA[ 内容変更]
Very soon this web page will be famous amid all blogging and site-building people, due to it's pleasant articles or reviews|
2016-07-10 Sun 02:38 | URL | bubble guppie party #EBUSheBA[ 内容変更]
This is a really good tip especially to those fresh to the blogosphere. Simple but very precise info… Thank you for sharing this one. A must read post!|
2016-06-26 Sun 00:32 | URL | get redirected here #EBUSheBA[ 内容変更]
I'm really enjoying the theme/design of your web site. Do you ever run into any web browser compatibility issues? A few of my blog visitors have complained about my site not operating correctly in Explorer but looks great in Safari. Do you have any suggestions to help fix this issue?|
2016-06-25 Sat 12:53 | URL | simply click the next web page #EBUSheBA[ 内容変更]
It's perfect time to make a few plans for the future and it is time to be happy. I have learn this publish and if I could I wish to suggest you few interesting issues or advice. Perhaps you can write next articles regarding this article. I desire to read more things approximately it!|
2016-06-25 Sat 00:43 | URL | other #EBUSheBA[ 内容変更]
I really like what you guys are usually up too. This sort of clever work and exposure! Keep up the amazing works guys I've included you guys to my personal blogroll.|
2016-06-24 Fri 14:55 | URL | simply click the up coming post #EBUSheBA[ 内容変更]
Unquestionably believe that which you stated. Your favourite justification seemed to be on the web the simplest thing to take into accout of. I say to you, I certainly get annoyed at the same time as people consider concerns that they just don't recognize about. You managed to hit the nail upon the top and defined out the whole thing with no need side-effects , other folks could take a signal. Will probably be back to get more. Thank you|
2016-06-24 Fri 05:19 | URL | Visit Home Page #EBUSheBA[ 内容変更]
If you desire to obtain much from this paragraph then you have to apply these strategies to your won web site.|
2016-06-23 Thu 17:30 | URL | Our Web Site #EBUSheBA[ 内容変更]
I read this article completely regarding the resemblance of latest and previous technologies, it's awesome article.|
2016-06-23 Thu 07:40 | URL | sources #EBUSheBA[ 内容変更]
My brother recommended I may like this website. He was totally right. This submit truly made my day. You can not consider simply how much time I had spent for this information! Thank you!|
2016-06-09 Thu 16:16 | URL | time management games blackberry #EBUSheBA[ 内容変更]
Hi! I know this is kinda off topic but I'd figured I'd ask. Would you be interested in exchanging links or maybe guest writing a blog article or vice-versa? My website goes over a lot of the same subjects as yours and I believe we could greatly benefit from each other. If you happen to be interested feel free to shoot me an e-mail. I look forward to hearing from you! Awesome blog by the way!|
2016-05-19 Thu 13:47 | URL | cccam server #EBUSheBA[ 内容変更]
I really like what you guys are up too. This sort of clever work and coverage! Keep up the good works guys I've included you guys to my own blogroll.|
2016-05-10 Tue 11:24 | URL | find fat diminisher on here #EBUSheBA[ 内容変更]
My partner and I stumbled over here by a different website and thought I might as well check things out. I like what I see so now i'm following you. Look forward to checking out your web page repeatedly.|
2016-05-10 Tue 08:44 | URL | Check out #EBUSheBA[ 内容変更]
Thanks for ones marvelous posting! I definitely enjoyed reading it, you're a great author. I will ensure that I bookmark your blog and may come back someday. I want to encourage one to continue your great posts, have a nice day!|
2016-04-13 Wed 21:10 | URL | magick #EBUSheBA[ 内容変更]
I am regular reader, how are you everybody? This post posted at this web site is genuinely fastidious.|
2016-04-13 Wed 02:16 | URL | baton rouge notary #EBUSheBA[ 内容変更]
Nice replies in return of this question with solid arguments and telling the whole thing concerning that.|
2016-04-08 Fri 06:05 | URL | 1/4-Inch Drive Click Torque Wrench #EBUSheBA[ 内容変更]
Excellent web site. Plenty of useful information here. I am sending it to a few buddies ans additionally sharing in delicious. And naturally, thank you on your sweat!|
http://gymnasticsmats.net/ http://bit.ly/1W7QMPX
2015-10-01 Thu 00:07 | URL | http://gymnasticsmats.net/ #EBUSheBA[ 内容変更]
I think the admin of this web site is really working hard in favor of his web site, for the reason that here every stuff is quality based data.|
gymnastics mats http://bit.ly/1W7QMPX
2015-09-30 Wed 23:50 | URL | gymnastics mats #EBUSheBA[ 内容変更]
It's amazing to go to see this web site and reading the views of all friends concerning this article, while I am also keen of getting experience.|
gymnastics mats http://bit.ly/1W7QMPX
2015-09-30 Wed 23:07 | URL | gymnastics mats #EBUSheBA[ 内容変更]
I do not even know the way I ended up here, but I thought this submit was once great. I don't recognize who you are however definitely you are going to a well-known blogger in the event you aren't already. Cheers!|
http://gymnasticsmats.net/ http://bit.ly/1W7QMPX
2015-09-30 Wed 23:07 | URL | http://gymnasticsmats.net/ #EBUSheBA[ 内容変更]
Howdy! I simply would like to give you a huge thumbs up for your excellent info you've got here on this post. I will be coming back to your web site for more soon.|
gymnastics mats http://bit.ly/1W7QMPX
2015-09-16 Wed 11:06 | URL | gymnastics mats #EBUSheBA[ 内容変更]
2015-09-16 Wed 11:05 | URL | nike free sneaker #EBUSheBA[ 内容変更]
2015-09-13 Sun 15:57 | URL | nike free 7.0 mens #EBUSheBA[ 内容変更]
2015-09-13 Sun 15:57 | URL | nike air free 5.0 #EBUSheBA[ 内容変更]
2015-09-13 Sun 01:25 | URL | nike mercurial bag #EBUSheBA[ 内容変更]
コメントの投稿
 

管理者だけに閲覧
 

この記事のトラックバック
| のぶかつの部活動 since 1970 |