New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Cntl Save Entr returns text formula

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Cntl Save Entr returns text formula

Postby asnead » Fri Apr 01, 2016 7:15 pm

Semi-new to Excel, working with 2013 version. Trying to figure out the FREQUENCY function, I am following the steps in all of the tutorials, the cells are formatted to numbers. I highlight the area that I want the information returned in the spreadsheet, enter the formula in the formula bar as =frequency(DataTableName,RangeTableName) then hold down CSE and all it does is copy the exact text I just typed into all the cells. How do I get the brackets to show up and do their magic?
Thanks
  • 0

asnead
Rookie
 
Posts: 1
Joined: Apr 1, 2016
Reputation: 0
Excel Version: 2013

Re: Cntl Save Entr returns text formula

Postby pecoflyer » Sun Apr 03, 2016 9:55 am

Hi and welcome to the board

Did you hit CSE with the insertion point in the formula bar?
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 14 guests