Question about Computers & Internet

1 Answer

I "fat-fingered" something while typing some numbers into my excel spreadsheet, and now only the suport "upper case" of the numbers of my number section work--so I am unable to now type numbers into a cell

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

  • Expert
  • 287 Answers

Does your k/b have a "shift lock" button... if so press it to disable the "shift lock"

If using the numeric keypad, ensure you have "num lock" ON

HIH

Posted on Jul 19, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Can information on an Excel spreadsheet be transferred to a Word spreadsheet to use as a "Word Merge" document, and if so, what is the procedure for this?


go google and type in --user manual for excel--
there is a pdf version for download , around 900 pages which explains in detail everything you need to know on how to do what in excel
there are shorter version that deal with specific topics so cruise the sites until you get exactly what you want

Jan 18, 2017 | Excel Computers & Internet

Tip

Copy PDF tables to excel?


"I have a national statistics book in PDF, it has a number of tables I want to work with in excel. So I paste all the colums and copy in Excel. However, the format is wrong, all colums in a single excel colum. How can i deal with it, any suggestion?"<br /><br />Are you also be troubled with the problem? Here share you an easy solution to solve it.<br /><br />The PDF to Excel Converter can convert PDF to Excel, convert PDF eBooks to Excel on Mac with more accurate-looking and highly-editable XLS files. There will be no need to reformat the converted Spreadsheets. PDF to Excel Converter for Mac makes it a clinch to re-use tables and spreadsheets from PDF files in Microsoft Excel.<br /><br />Get a <a href="http://www.doremisoft.com/pdf/pdf-to-excel-xls-converter-mac.html"><span style="font-weight: bold;">PDF to Excel Converter for Mac </span></a>users or <a href="http://www.doremisoft.com/pdf/pdf-to-excel-converter.html"><span style="font-weight: bold;">PDF to Excel Converter</span></a> on Windows OS<br /><br />Free download it and get a free try!<br />

on Nov 23, 2010 | Computers & Internet

Tip

How to recover Excel 2007 password


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password
Set a password to open Excel 2007
  • 1. Click the Microsoft Office Button 3dac3a8.gif, point to Prepare, and then click Encrypt Document
  • fd07008.gif
  • 2. In the Password box, type a password, and then click OK.
  • You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  • 3. In the Reenter password box, type the password again, and then click OK.
  • 4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet
  • In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  • 1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  • 2. On the Tools menu, click General Options. The General Options dialog opens.
  • 3. Under File sharing, in the Password to modify box, type a password.
  • 4. In the Confirm Password dialog, re-type the password. Click OK.
  • 5. Click Save.
Remove password protection from an Excel spreadsheet
  • 1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  • 2. Click the Microsoft Office Button 3dac3a8.gif , point to Prepare, and then click Encrypt Document.
  • 245e5bd.gif
  • 3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  • 4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007

on Jun 09, 2010 | Audio Players & Recorders

1 Answer

Unable to type in microsoft excel spreadsheet


Couple of possibilities:

The active window is selected.

Some cells might be formatted for numbers only. Check cell format.

Your font is white and you can't see your typing.

Oct 03, 2010 | Microsoft Office Excel 2007 Full Version...

Tip

How to set, modify, remove and recover Excel 2007 password?


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password Set a password to open Excel 2007
  1. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document. excel-document.gif
  2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  3. In the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.
Remove password protection from an Excel spreadsheet
  1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  2. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document.

    excel-document.gif

  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
Related Office 2007 document password tips:
How to set, modify, remove and recover Word 2007 password?
How to set, modify, remove and recover PowerPoint 2007 password?

on May 21, 2010 | Computers & Internet

1 Answer

Need Formula


TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

2 Answers

MS Wireless Optical Mouse 5000 - Magnifier


All the buttons are programable and easily accessed through the mouse icon in the startup menue. Click Statup, Click the mouse program icon, a window appears with each of the mouse buttons listed with drop down menues. Click the drop down menue of the button of interest, select one of about 20 choices (in my case "disabled"), click Apply, click Save.

Dec 10, 2008 | Platinum Microsoft Wireless Optical Mouse...

1 Answer

Excel spreadsheet is protected. I do not remember the password. how can i get in?


lok on google for password cracker for excel download and it will open any locked spreadsheet

Oct 14, 2008 | Microsoft Office Standard for PC

1 Answer

Want to update the dates in excel spreadsheet


Try inserting seperate entry for furture day number and then reference that entry address for program math. You will have to either use same number of days to repeat (automatic) this math or accept that it would be a single shot type math. Depending on which version of excel you are using the alert can be a sound or color change. If 97 or older, there is no alert available. 2000 isn't much better.
Easier to set furture date in orginial date block right from the start. Unless you are running the excel program continuously in the background, program will only check date when running.

Good Luck,

Jan 16, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

52 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...